Keywords for crystal command using IBM iSeries ODBC Driver DB2 UDB

[BandOQ4b]

Writting reports using "command" accessing an AS/400 database using IBM iSeries ODBC Driver DB2 UDB. Most of the standard SQL commands don't work. ie.
currentdate needs to be curdate () and it will not accept any back dating (-1).
convert can not be used only cast
Does anyone know of a source to find acceptable keywords for this situation?

 

[Turkbear]

Hi,
See if this helps:

ftp://ftp.software.ibm.com/ps/products/db2/info/vr7/pdf/letter/db2s0e70.pdf





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[BandOQ4b]

Thanks, It will take awhile to go through that. If someone has a short version that summerizes commands that would be helpfull also.

 

[Turkbear]

Hi,
This one may be quicker to use:

http://publib.boulder.ibm.com/infoc...m.etools.iseries.langref2.doc/rbafzmst167.htm

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[BandOQ4b]

Thanks, the version is easier to find things. I will use the first for more detail.