RPG/RPGLE convert to SQLRPGLE

[sintaq]

hi all..

i'm new to sqlrpgle and started to explore it. i'm thinking of converting my current rpgle programs to sqlrpgle.
what are the impact that i should consider? i means, in term of programs compatibility with CL,DSPF,PRTF etc?
hope i get my question clear. thanx

[K2r400]

Re: RPG/RPGLE convert to SQLRPGLE

No incidence.
Take a source of RPGLE, modify it to SQLRPGLE and compile.
The behavior is the same.

[BenThurley]

Re: RPG/RPGLE convert to SQLRPGLE

The only problem I get when converting an RPGLE program to a SQLRPGLE is in WSDC. It caches source members to the local file system when you edit them and it gives a different file extension depending on if it is SQL or not.
E.g.
MYMBR.rpgle becomes MYMBR.sqlrpgle

The problem in WSDC is that it keeps the old cached *.rpgle and so doesn't update the file type. It then complains all the time because it thinks the SQL statements aren't valid code and the program won't compile because it will issue the wrong command. The only way I have found to resolve it is to find the cached file manually and delete it. We use a change control plugin though which could be shafting it.

Oh yeah, and when you compile in WSDC it doesn't give you the line numbers you need because it first goes through a SQL pre-compiler which replaces your exec-sql statements with fixed format RPG which increases the number of lines. There was a previous thread on this topic.

Other than that they're not a lot different.

[sintaq]

Re: RPG/RPGLE convert to SQLRPGLE

K2r400: noted! thanx

BenThuryley: noted! i believed WSDC = websphere studio right? i came across other thread http://www.code400.com/forum/showthr...List-Behaviour which i believed regarding to the matter that u mentioned.anyway, i 'm using SEU so i hope it should be ok.

[BenThurley]

Re: RPG/RPGLE convert to SQLRPGLE

I believed WSDC = websphere studio right?

That's correct.

[Mercury]

Re: RPG/RPGLE convert to SQLRPGLE

If you would like to be kept informed you can also look here.

[sintaq]

Re: RPG/RPGLE convert to SQLRPGLE

thanx guys. appreciated it!