• Error code 10: Function sequence error using CPYTOIMPF on AS/400

    I am using the CPYTOIMPF function on an AS400 to copy from one data base file to another. I want to end up with a .CSV file format. It worked once but now I get the following error: Message Id: SQ999999 Error occurred in SQL Call Level Interface. A procedure call encountered an error. The error...

    AS400 - Ask the Expert485 pointsBadges:
  • cl

    Hi 1.I need a cl code that will purge text files that are more than 3 months old...text files will be created with the date of creation suffixed to the filename... 2.If the above is not possible will i be able to create flat file members and purge those file members.

    0 pointsBadges:
  • CPYTOIMPF – SQL ERROR

    I am using CPYTOIMPF to copy AS400 database file to another AS400 database to get the receiver file in .csv format to download to a pc folder. I get a SQL error " Error occured in SQL Call Level Interface. Function sequence error." Does anyone know what this error means? I know that my receiver...

    Ann45 pointsBadges:
  • Embedded SQL to process ALL members

    Hi, I'm trying to get an RPG with embedded SQL to read all the members in a file. I know I used to be able to do this with an OVRDBF command with *ALL specified for the member, but this doesn't seem to work anymore. In the joblog I get a CPF4268 message which says the file has no members or is not...

    Gilly40023,730 pointsBadges:
  • How to create a Data Area with RPG for storing variables

    How to create a data area using an RPG.I need to create a data area and store some values in it.The value to be stored are also retrieved from the same RPG.(that is from screen variables)

    0 pointsBadges:
  • SQL Stored Procedure

    I need to create a stored procedure with an input parameter of member name to create an Alias, select all the data in the member then drop the Alias. This procdure wil be called by 3rd party software using an odbc connection.

    Markpg155 pointsBadges:
  • Need a CL to be written

    Hi I need a cl to be written;The requirement is as follows There will be files created with naming convention INV20081219 or members within files. Now i need a program that will automatically delete files that are more than 3 months old.

    0 pointsBadges:
  • Using the SQL IN clause in SQLRPGLE

    Can I use a variable with the IN clause in an iSeries SQLRPGLE program? Can I use: WHERE CUSTID IN(:CUSTNUMS) Instead of: WHERE CUSTID IN(145,1600,352)

    PWMASI5 pointsBadges:
  • Program Described Files?

    Whats the use of program described file any example with file dds please?

    6r1,590 pointsBadges:
  • Copying a USRPRF to create a new one

    Copied user A's profile to create user B. However, objects owned by A did not get copied on B's profile. How do I add about 50 objs owned by A to B's profile? Thanks.

    Handlethis25 pointsBadges:
  • IT careers: Mainframes versus midrange

    In the future, which is better: being in mainframes or as400?

    AS400 - Ask the Expert485 pointsBadges:
  • Query 400 – SSN

    Hi all, I need to strip all but the last 4 digits of employees SSN in a file...I cannot remember what the string is!!! Can someone help? BTW, the current field has NO dashes in the SSN. Thanks in advance!! Rick

    Rmason345 pointsBadges:
  • OPNQRY and WRKQRY

    In wrkqry there is an option to save the selected records to an output file.Similarly is there a way to use OPNQRY in a CL or in an SQLRPG to directly move the selected records to another file?

    0 pointsBadges:
  • Send Object

    Dear , How i can send one object from One Server to another server please tell me step by step and which command is use Regards, SNK

    RNK5 pointsBadges:
  • AS/400 script or program needed

    I want script or a program which can be called so that i can get the specific information from the system and prints for me in Spool file. For example, i want to know all the PF which are attached to Triggers and their action and also the library. Can any one give a sample script for this or any...

    ITStarter5 pointsBadges:
  • Problem with CCSID ?

    Hi Our iSeries is on V5R4 and hosts a few Lotus Domino Servers... The Domino servers runs scheduled agents which create CSV File stored on the IFS. I can access and open these CSV files under Windows (with this syntax \\SERVER\SHAREDFOLDER)but the content is like this :...

    BruceWayne4,110 pointsBadges:
  • Create Alias In Rexx

    I am trying to execute the sql create alias in a rexx source however it fails with sql error 901, have tried command manually & works fine

    Markpg155 pointsBadges:
  • CLLE File Declaration

    Can display File and PF be declared in a CLLE program

    VPAIS5 pointsBadges:
  • RECLAIM STORAGE

    hello eveerybody: what do I have to know to execute reclaim storage command? These are the characteristics of our machine: Machine: Sistema: S106887C SO: V5R2M0 Tipo Modelo: 9406 Codig Caract procesador: 7408 Caract procesador: 2464 thanks

    Florez575 pointsBadges:
  • Decimal data error

    For testing an RPG program, I changed the CL program which submits the RPG program to a “call”. The change was to include a new parameter (numeric) to the RPG program. After testing, the Call was changed back to SBMJOB, but when tested again, the RPG program bombed with ‘decimal data...

    Moksha20 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