• Reading COBOL indexed file in SQL procedure in iSeries

    How do I read a COBOL indexed file in SQL procedure in iSeries?

    Bhusha40 pointsBadges:
  • Compile Program for previous system level

    Hi, My system is on IBM i V7R1. I have a SQL procedure on AS/400 created using "CREATE PROCEDURE" command on SQL400 command prompt. By default resultant Program object is created with CLE attribute & for System Level V7R1M0. I want to compile this program for System Level V6R1M1. How to do this...

    Ketan19305 pointsBadges:
  • Debug

    How to debug an SQL Stored Procedure?

    bigT35 pointsBadges:
  • How to insert data from SQL procedure

    How can I insert data from SQL procedure. I am using cursor.

    97834441841,465 pointsBadges:

    i hav code   STRQMQRY QMQRY(SQLPROC) OUTPUT(*OUTFILE) + OUTFILE(QTEMP/SQLDT)   In SQLProc txt file i am callin a sql procedure , developed using i series navigator and return data set using cursor. i want this cursor output in qtemp/sqldt file. in sqlproc if i mentioned SELECT statment , then it...

    Sanashakeel15 pointsBadges:
  • Getting error when i am trying to insert the record in QTEMP file trough QSH DB2 command

    i am trying to insert the record in QTEMP file trough QSH DB2 command but getting an error that file not found in QTEMP eventhough file is available in QTEMP. if i am giving my local libary instead of QTEMP then its working perfectly.

    Mdshadabalam130 pointsBadges:
  • Can you use variables as input and output when calling a stored procedure in COBOL?

    If you move data into your variable before calling your procedure, can the procedure then return a value back, which might be different? The procedure will intially be searching for the variable data, but, according to our .net programmer, will return a blank or null if it does not find the data....

    Bunkyg15 pointsBadges:
  • Do I need SQL?

    DO I need it? I am just a home user anf oerform simole tasks, but have 8 examples of SQL programs in my program list. I have win 7 64 bit O/S

    0 pointsBadges:
  • Documenting stored procedure jobs in SQL 2005 enterprise

    Our consultant created several stored procedure jobs within SQL 2005 enterprise. How can we view them to document them? SQL runs on a Windows 2008 box with 32gb of memory.

    TeachMeIT975 pointsBadges:
  • Why are naturl JOIN keywords not an option for producing a self-join?

    Why are naturl JOIN keywords not an option for producing a self-join?

    Meganlh5 pointsBadges:
  • SQL proceedure to join header and detail file

    I want to know how to set up a SQL procedure that joins a header file and detail file where the status field in header = 'X' then updates this header record after selecting the detail records.

    AS400 - Ask the Expert485 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.