• 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:
  • How to retreive stored procedure from DB2/400

    How to retrieve the stored procedure body from db2/as400. for example : I created a Stored Procedure as create procedure botest/spload ... ...

    Sivu105 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:
  • Logical file Error.

    i try to create Multiple-format Logical File but i getting compile time error. i have two PF dds is as follow.. A          R RDEPTMST                A            DEPTNAME      15        A            DID            5        A            LNAME      ...

    Nikrajpapa230 pointsBadges:
  • pass array to clle

    i created RPGLE,within that i defined compiled time array now i want to pass that array (at a time only one insex) to cllle but while i run this rpgle its give me run time error ..that  Error occurred while calling program or procedure *LIBL/practcl8 Message ID . . . . . . :   RNQ0211      ...

    Nikrajpapa230 pointsBadges:
  • What are the steps needs to be followed while removing Key Fields from PF.

    Hi, i have got a requirement to remove the Key Fields from the PF. Can anybody please suggest what are all the sequence of steps i shd follow to incorporate this changes to avoid any issues in Production after change. As per my knowledge below are the steps i am planning to follow, please confirm....

    Mohan K695 pointsBadges:
  • Moving file from Linux to AS/400

    how can i get a file from linux to my as400 use to do it with Client Assist but being told that does not exist in linux !

    WILBE5 pointsBadges:
  • Not able to create procedures using STRSQL on V6R1

    While creating a procedure in V6R1, [strong]Not authorized to CREATE PROCEDURE error (Message ID is SQL0552)[/strong] appears. In Additional Message Information cause of the error being -- [strong]CREATE PROCEDURE or CREATE FUNCTION requires the *OBJOPR and *ADD authority to the catalog table...

    Haaiderali215 pointsBadges:
  • Switch between two screens using CICS maps

    how we can switch between two screens using maps in cics what will be the logic implemented in cobol programme?

    Asstenggtrainee5 pointsBadges:
  • Connecting SAP to iSeries.

    We are undergoing a project implementation in which we need to connect SAP to iSeries where SAP would be the target for fetching data from iSeries which is the source. Can anyone help me by providing the steps involved for Connecting SAP to iSeries. Also let me know if any addtional product is to...

    Haaiderali215 pointsBadges:
  • VSAM versus DB2 in CPU consumption

    Is it possible estimate how much more CPU is consumed by DB2 commands in relation to VSAM KSDS when access a row, through an index scan, in a organized DB2 table against a record reading from an organized VSAM KSDS file through the primary index? How much is it in percentage? Thank you very much in...

    Abelmart30 pointsBadges:
  • Using Dropbox and Radio button with DB2400

    IS THAT POSSIBLE OF USING DROPBOX AND RADIO BUTTON IN DB2400?

    Rajasekhar151,395 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:
  • Synon (Migration)

    Dear Friends, We are in a plan of migrating system to some other technology like Java/.NET etc. Please find the details and questions below. Information about the current System: Synon (CA -2E) 8.5 Version Few modules the source is getting generated in COBOL and other in RPG Database we using...

    BibinG20 pointsBadges:
  • record locking in As/400

    HI can anybody tell me about how to handle the Record locking situation when more than one user tries to access the same record in a physical file....?

    ten20081,150 pointsBadges:
  • DB2 for Z/OS and DB2 for LINUX / WINDOWS/ AS400

    I have around 5 years of IT experience in Mainframe and Midrange operations. As I'm more intersted in database administration, recently I did IBM DB2 9 Fundamentals certification and also IBM Mainframe application development course ( JCL,VSAM,COBOL,DB2,CICS) but it was 5 years back. I want to go...

    Sarada1115 pointsBadges:
  • String Aggregate Function

    I need a report that provides an aggregate of a string column - in this case a concatenation of the values in a comma separated string. There is no such DB2 aggregate function that does this. A stored procedure (or possibly a customer aggregate function?) seems the only likely way to accomplish...

    Mgemmill5 pointsBadges:
  • Comparing DB2 between AS/400 and mainframes

    How different is DB2 for AS/400 and for mainframe? For example, the high-level DB2 administrative privileges. Catalog names such as SYSADM, SYSCTRL, SYSOPR, DBADM, PACKADM, DBMAINT, DBCTRL, or catalog views such as SYSCAT.DBAUTH, SYSCAT.COLAUTH, SYSCAT.TABAUTH etc, are they using the same names for...

    Dwiningsih25 pointsBadges:
  • Compare files in AS400

    When i compare two files using CMPPFM command, i am getting message as request failed. This is because files were having huge volume of data. It was showing file exceeds 112498 records. Is there any other way to compare files of large volume of data in AS400. Please let me know.

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

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