1
  • How to show table Constraints on AS/400

    Hello masters, I want to show table constraints on as400 database.I asked somebody people and they are said me; "Do not show (constraints - table relations) on AS/400". I don't believe that. And now asked How to show table constraints - relations on AS/400 I'm very curious about the answer to this...

    HBurakKaradag15 pointsBadges:
  • sql not retuning column using DB2 data reader

    Strange one. I have a user that created a database file using WRKQRY. In this file is a user defined result field. Its basically a text label stating the build level 'LVL01'. After all levels are run (11 total) the file is complete. I am trying to access this data using a .NET program and a iDB2...

    ToddN20008,100 pointsBadges:
  • Uploading records in a text file

    Hi.. I have PF with this format Ex: PF1 R REC FLD1 FLD2 For the above PF1 file I have records in a text file. For that I need to upload the records without using iSeries navigator and FTP also. Can anyone guide me? Regards, Ajmal khan.

    shyedajmal285 pointsBadges:
  • AS/400 query for logical file

    I have one join file and one logical file. It is possible to create logical file on join logical file?

    anupsshelke420 pointsBadges:
  • Do we need to compile LF when its PF changes

    Hi, I have one small query. I have changed one PF, do I need to recompile it's dependent LF(s) ? For e.g I have earlier a PF say PF1 having 4 fields A,B,C,D (with keys A,B) now I have added a new field E. Do I need to recompile its dependent LFs say LF1,LF2.. Appreciate your quick response !

    pankaj2r100 pointsBadges:
  • physical files……

    hello sir,             I have found one problem while update data in source file. I creats one source file after 14 it shows this message "The compile of member JPF1 was submitted to Batch.                          + Job 476274/NITINB/JPF1 submitted to job queue...

    anupsshelke420 pointsBadges:
  • AS400 and BOXIR3.1 connectivity

    Hi guys, Can anybody tell if Business object can be connected to AS400? Thanks Pranav Sharma

    PranavSharma35 pointsBadges:
  • How to acheive FULL OUTER JOIN on three files in IN SQLRPGLE program.

    Hi, I have 3 seperate files called Duty, Freight and Brokerage and i need to process all the records from all the three files into one output file based on key values matching across all the files, if i dont find the match in anyother two files then i need to populate coresponding fields with...

    Mohan K695 pointsBadges:
  • enter SRTSQL Satements AS400

    Hi, I have done an index by "create index......" and when I am trying to do aquery with STRSQL on that index I receive the following error: BKPPDAI1 in BKTEST not table, view, or physical file. This is my Statement: select *from bktest/BKPPDAI1 I am trying to fix the syntaxis but I can not make it...

    JEMC5 pointsBadges:
  • how to write more than one sql statement under EXEC SQL in SQLRPGLE.

    Hi, Can anyone please help me to write more than one SQL statements under single EXEC SQL and END EXEC as below. Since i have 10 sql statements and wanted to include all those 10 statements under single block of EXEC SQL and END EXEC by using any seperator like below. C/EXEC SQL C+Insert into A...

    Mohan K695 pointsBadges:
  • User cannot run a job that another use has access to do

    How do I give a user access to run a job?

    658820 pointsBadges:
  • Production support team in AS400

    In AS/400 projects in Companies whats the meaning of production support team.what production support involves.also what work does development,maintenance involve what are the other teams or processes that are available for as400 project. 

    Kaly470 pointsBadges:
  • File Level identifier Vs. Record Format Level Identifier vs. Member level identifier

    Hi,   Please let me know the difference b/n File Level identifier, Record Format Level Identifier and Member level identifier with an example

    AS400B20 pointsBadges:
  • How to Import Data from a .CSV or .XLSX file to an AS400 file?

    I want to import the data of a .CSV or .XLSX file to a AS400 file. How can I accomplish this? Also, the .CSV/.XLSX file has two columns that I would like to keep in the AS400 File. Any inputs would be really appreciated.

    Jorame5 pointsBadges:
  • I need help with DSPF…

    Hi everybody, i try explain my need. I have one RPG pgm with several DSPF, and for this work well, i have a OVRDSPF. My problem is when other people make any changes in one DSPF we have a level check, i know that, but because of this i need a idea for make an ALERT inside of DSPF source code in...

    BUG68235 pointsBadges:
  • Difference between RPGIII RPG IV and RPGLE

    1)Can some one tell me the major differences between them? 2)Subprocedures, Built in func etc stuff does come under RPGIV or RPGLE? 3) I beleive Actiation groups, static Binding, modules, Service pgms.. does come under RPGLE? please explain me a bit clear, and it would be thankful if you have...

    Kar425 pointsBadges:
  • How to check existance of record without using file opcodes

    By using INFDS and standard fields *FILE/*RECORD.... how to find out a record existance in Physical File without using any file opcode? Please tell me the RPG code how to use it, not only the I spec definition.

    Kar425 pointsBadges:
  • Delete OLD files from Table not having date or timestamp

    Hi, In DB2, Is it possible to get the insert date of a record in a table which doesn't have a seperate field for creation date or timestamp. I have a task where I have to delete record older than 1 year from a table, but the files doesn't have creation date field. So, like RRN does DB2 have any...

    RJES45 pointsBadges:
1

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following