Re: Listing and viewing forms with DB2/AS400

souporpower@xxxxxxxxx wrote:
Hi Folks

I work as a programmer in a call center. The call center people are
pulling forms on the terminal and some times enter/modify data to
update the DB2 in the back end. They are too busy to approach and
bother with mundane questions. Besides I believe learning from Usenet
groups is a must for a buddinig AS400/DB2 programmer.

Now my question: can someone please tell me how to list all of the
available forms in iSeries/Navigator?

What I want to do is open a form, enter some data and update the DB2.
Then I want to run a query that calls a stored procedure in the
backend for update.

So I need 2 things:

a) list of forms
b) list of stored procedures behind the form

I am now facing another problem. With STRSQL (iSeries/Navigator SQL
pre-compiler)
I am unable to run a stored procedure with question mark ("?"). For
exampel if sp1 is a stored procedure, when I type "CALL sp1(?)" I get
"use of parameter marker not valid" message. Someone told me that it
is because there is no working memory in the iSeries/Navigator to
store temporary results.

This is my wish list for Christmas. :) Please help

Thanks

You might have to take it up with your manager or the application vendor. You seem to want to fire away queries/SPs on the database etc but have no fundamental understanding of the environment nor the application layer and sound a bit flaky on the database side (eg. PL/SQL is in Oracle not DB2). The lack of support from anyone else in organisation just sounds really suspicious.

The worse part is you've got access to some tools through which you can play. Be really careful mate as you can do some major damage to the data integrity of the app.

RJ.
.

Relevant Pages

  • Listing and viewing forms with DB2/AS400
    ... I work as a programmer in a call center. ... pulling forms on the terminal and some times enter/modify data to ... With STRSQL (iSeries/Navigator SQL ... I am unable to run a stored procedure with question mark. ...
    (comp.sys.ibm.as400.misc)
  • Re: Listing and viewing forms with DB2/AS400
    ... I work as a programmer in a call center. ... available forms in iSeries/Navigator? ... I am unable to run a stored procedure with question mark. ... is only for prepared statements, with iSeries/Navigator you run immediate statements only. ...
    (comp.sys.ibm.as400.misc)
  • Re: Listing and viewing forms with DB2/AS400
    ... I work as a programmer in a call center. ... Then I want to run a query that calls a stored procedure in the ... prepared statements only in HLL programs. ... DECLARE cursor_name CURSOR FOR statement_name ...
    (comp.sys.ibm.as400.misc)
  • Re: Listing and viewing forms with DB2/AS400
    ... I work as a programmer in a call center. ... Then I want to run a query that calls a stored procedure in the ... prepared statements only in HLL programs. ... in any other language supported by SQL Developer Toolkit. ...
    (comp.sys.ibm.as400.misc)
  • RE: Calling DB2 Stored Procedures through DBD::ODBC
    ... > connecting to DB2 ... The short answer is you need the ODBC syntax wrapped around it. ... > The second thing is if I can run the stored procedure through ...
    (perl.dbi.users)