• Printer drops out when spool file goes to associated Output Queue

    We have a Xerox Phaser4500 printer config as a 3812. Recently our third party software ACOM creates a merged CHECK spoolfile (its an *userascii) type from mapping and sends it to our outq. The spoolfile will show "WTR" and nothing prints. The printer then has to be turn off and on again. And then...

    Donna5 pointsBadges:
  • Native database implementation on AS/400

    Hi, I am searching for a native database implementation for AS400. Either an open source or that can be bought and used or ( a database impl that can be achieved by doing some programming). Can i get some help regarding this. Thanks all, teja.

    Engineerteja5 pointsBadges:
  • seect records for current day

    I want to run a daily job and select records that have been added on current date, field is 6,0 P in YYMMDD format, how can this be accomplished without modifying daily?

    rmb115 pointsBadges:
  • validation

    i need to concatinate two fields and send to resultant field in rpg/400. one is numeric and other one is character. so please advice how can i

    Askt1140 pointsBadges:
  • Impact of upgrading the iSeries OS from V5R3 to V5R4 on Content Manager for iSeries

    Hi, We are upgrading the iSeries OS from V5R3 to V5R4.Will there be any impacts on Content Manager for iSeries (V5R3). I wanted to make sure if following supported on V5R4 1)Content Manager SW 2)Content Manager iSeries Client Conc User Lic 3)Content Manager iSeries Server 4)DB2 CM ONDemand for...

    Shichy20 pointsBadges:
  • 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:
  • Easiest way to swap drives on 9406-520 AS/400

    I have a 9406-520 with six (every slot full) 36 GB drives. We need to replace all six drives, with six 73 GB drives. What's the easiest, quickest way to accomplish this task? Thanks!!

    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:

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