Avatar of rhservan
rhservan
Flag for United States of America asked on

What is an excellent SQL reference for AS400 DB2? EZ for DB2 Pro

I am creating stored procedures and queries on an AS400 DB2 system to interface on the as400 connector to SSRS and need a very good reference docuement for writing SQL.
DB2SSRSSQL

Avatar of undefined
Last Comment
rhservan

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Member_2_2484401

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
lcohan

If you are writing the code in AS400 as mentioned please provide what language of choice you want it into. If you use RPG then below is a good reference:

http://www.redbooks.ibm.com/redbooks/pdfs/sg245402.pdf


For SQL:
http://www.sql-server-performance.com/2003/stored-procedures-basics/
http://www.mssqltips.com/sqlservertutorial/160/sql-server-stored-procedure/
Member_2_276102

It looks like there might be two parts to your question. First is about creating procs and queries on the AS/400. But it continues with a reference to "the as400 connector to SSRS" and a more generic "for writing SQL."

Are you asking specifically about writing SQL that will run on the AS/400? Or are you needing info about SQL on some other platform that will connect across your network to the procs on your AS/400?

The previous comments are very good. But if you need info about SQL on the AS/400, you will want links for the AS/400 SQL references for the OS version that's on your AS/400.

What OS version/release is installed?

Tom
rhservan

ASKER
I have the connector - 0le DB for DB2 - from Microsoft.
I need a stored procedure to run from the AS400 DB2 environment to MS SSRS in Visual Studio.
What I have is working for data, however, when I add parameters the parameters get created on the MS side in SSRS but then the columns and data are lost.

So if you know how to fix this or you can provide a comprehensive guide to address these issues between the two differing environments will get you the points.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes