• DB2/400 SQL Sub Query Performance?

    Here is the problem. Table INVEHH is a (Events header table) with about 500 records and INVEHD (Event Details) with about 22 million records. These tables are on a DB2/400 database. 1) Original Query that takes forever: select EVENT, INUMBR, ISTORE, EVHYY, EVHMM, EVHDD from INVEHD where EVENT in...

    Apothen0 pointsBadges:
  • SQL View over a table with members

    Hi all, I have an as/400 table(fileA) with several members, I need to create view that joins this to several other tables but but I need to only target one member in fileA. The other tables are all single member tables. I tried to create an alias over the table and then create the view but that is...

    Lpgast0 pointsBadges:
  • MS Query – Client Access DSN error

    I'm receiving SQL0901 error when I establish a connection through MS Query to the 400. The job log failure is QQQISVSU (level 40) stating "Attributes of value number 2 in field HVR0002 not valid" I've disabled query wizard in hopes that the SQL request would not be made and it gives the same error....

    Jsimmons0 pointsBadges:
  • Moving spool files from one AS400 to another

    I'm having a problem retaining the spool file attributes when I tranfer spool files from one ISeries to another. I can use the SNDTCPSPLF and it retains most of the attributes but does not retain the user and date/time attributes of the original spool file. Any suggestions??

    Pperry0 pointsBadges:
  • Calling External Procedure from Java Web based Application

    Below given is a procedure to access a CL Program in iSeries from a Java web based program. create procedure libxxx/proc_name LANGUAGE CL FENCED EXTERNAL NAME 'libxxx/clprogram' PARAMETER STYLE GENERAL The external CL program has other calls to Cobol programs in the same library.The procedure is in...

    TOKNOWIT0 pointsBadges:
  • Update help needed

    I need to perform an update as follows... Update LIBNAME.SDFILE Inner Join LIBNAME.DXFILE On SDPRDC = DXPRDC And SDSENO = DXSENO And SDORNO = DXORNO And SDLINE = DXLINE Set DXDNAM = '', DXDAD1 = '', DXDAD2 = '', DXDAD3 = '', DXDAD4 = '', DXDPCD = '', DXINVN = 0 Where SDIECD = 'SO' And SDCDAT <...

    SBatSI415 pointsBadges:
  • small doubt

    Hi, I have a small doubt in AS400 programming. This is regarding receiving journal entries. I am using ILE C to write the exit program. I am using RJNE0200 format on the RCVJRNE command. I am getting the entries in the exit program. But I have a few questions: - in the RJNE0200 format, there are...

    Pprasad1230 pointsBadges:
  • Changing the statement heap parameter on iSeries

    Hi, I would like to know how to change the statement heap parameter DB2 (stmtheap) on the AS/400. I tried the command GET DATABASE CONFIGURATION FOR database-alias (giving alias name as the AS/400 server name) but it returns the error "SQL0901N The SQL statement failed because of a non-severe...

    Sbkhole0 pointsBadges:
  • Inserting data into a vargraphic data type field

    How to insert data into a vargraphic data type field. I have done the following CREATE TABLE TEST_TABLE (FLD1 VARGRAPHIC(20)) This is done succesfully INSERT INTO TEST_TABLE VALUES('TEST') This gives a SQL error Please let me know how I can acheive it.

    Sbkhole0 pointsBadges:
  • SQL joining tables across multiple AS/400’s

    I would like to execute the following query. The problem is that the Table INVMST is on a different AS/400 than table CHURDLES. INSERT INTO IDEASLNT/SHURDLES SELECT I.IDEPT, I.ISDEPT, I.ICLAS, I.iSCLAS, I.ISTYL#,I.ASNUM, CONCAT(CONCAT(Digits(I.IDept), '-'), Digits(I.ISDEPT)),...

    Apothen0 pointsBadges:
  • WALLDATA RUMBA File Transfer Function

    After upgrading from NT to XP or Win2000, the File Transfer function no longer works. Arpeggio is fine but the File Transfer application error is:[Wall Data][Rumba Data Access]No data source specified; dialog prohibited. SQLDriverConnect.... Maybe there are registry entries missing?...

    RPGGuru0 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.