• Update join logical file

    I have seen one topic here before which saying that join logical file can be updated and it has been many years. But I have tried to update a join logical file either using DFU or STRSQL.Neither succeed. Could someone help on this? Thanks a a lot.

    Gaoshen10035 pointsBadges:
  • How to write Multiple format for physical file using QDDSSRC create PF

    FOUNDATION PHYSICAL FILE USING QDDSSRC  CREATE F6 UNIQUE R FORMAT01 FNO 5S TEXT('FOUNDATION NUMBER') NAME 50A TEXT('FOUNDATION NAM') ADD1 25A TEXT('ADDRESS 1') ADD2 25A TEXT('ADDRESS 2') CITY 30A TEXT('CITY') STATE 2A TEXT('STATE') ZIP 12A TEXT('ZIP CODE') COUNTRY 25A TEXT('COUNTRY') TEL 20A...

    sothonod45 pointsBadges:
  • CL program calling a RPG36 program

    Can a CL program call a RPG36 program? I'll just try it if no quick answer, but maybe you know this one.

    aceofdelts1,850 pointsBadges:
  • CPYF in arrival sequence

    Anyone know a quick and dirty to copy data from a keyed physical file to another physical in arrival sequence in a CLP program? I can't find a native os/400 command that will do it.

    Dasturg0 pointsBadges:
  • How to keep whitespace in datagrid

    I have a simple .NET app. You key a SQL statement into a text box. It then connects to any one of 5 i-Series and returns a datagrid. I am curious as to how I can preserve the whitespace in the columns. These columns have some fields with data right and left justified. Other fields a large field...

    ToddN20008,315 pointsBadges:
  • SQLRPGLE program results nothing

    Hi,  I am new to SQLRPGLE. I have coded something, which finally shows nothing.Please have a look on my code & kindly help me to get the output. This is my program         *************** Beginning of data ************************************ 0001.00 HDEBUG(*YES)                  ...

    HABBIE805 pointsBadges:
  • AS/400 CL to submit a Jobscheduler entry wont loop

    I have created a command which simply calls a CL called Booking which is below. It submits a program PC832U and re-adds itself to the job scheduler. So basically it is running every 5 minutes until 2pm. First call runs great. It runs the program and adds itself in the scheduler for 5 mins later....

    adamkm35 pointsBadges:
  • Getting the E8940 Error when connecting to AS/400

    Hi all I am using Personal Communication iSeries access for Windows to connect AS/400. It is giving me error E890 (Automatic configuration failed or not allowed) when trying to connect. I searched this error on internet and I found this technote by IBM. I am the only one who is using server....

    hunshabbir7920 pointsBadges:
  • Describe AS/400 command

    Hi, 'Describe select * from tablename'. We can use this statement from the DB2 command line , which results the complete definition of the table. Could you please tell me the same, which I can use from STRSQL, as describe is throwing an error. Thanks in advance

    HABBIE805 pointsBadges:
  • Monitoring IFS Directory in real time

    We have a requirement that people will FTP a file to IFS directory and we should monitor for arrival of the file and pick up the file and process in the application. Is there any way we can monitor IFS directory in real time for arrival of a new file. The file will be placed in IFS directory using...

    Babs312150 pointsBadges:
  • Massive bulk AS/400

    Is there a way to make a massive bulk for AS/400? For example: I have 5000 SKU's that we need to change price or cost. Right now, we do it manually. Is there a better and efficient way to do it?

    FELIXDIAZGARCIA25 pointsBadges:
  • AS/400 Compilation

    I am a beginner in AS/400. I have a question to ask. When we are compiling a Physical File, it will generate a unique code something like identifier right? So I will compile the program with this PF. Now my question is, if I have two libraries which contain this PF with same identifier, when I...

    yeepiyaya70 pointsBadges:
  • License expiration of Power 7 server

    How to check License expiration date of Power 7 Server licensed programs?

    Anshan20 pointsBadges:
  • AS/400 Query taking time to execute

    I am having a query which is having 7 inner join One table having record around ==>4770290 And second table with ==>50681241 And other tables have comparatively less records.

    jayshree185 pointsBadges:
  • SQLRPGLE Cursor not open error

    Hi, I have written some thing on SQLRPGLE. I am facing few issues.I request you to kindly look at the code & let me know the mistakes.Please forgive me ,If I made any blunders on this.   This is my file. 0001.00                 R EMP                             0002.00  ...

    HABBIE805 pointsBadges:
  • How to use OVRDBF to find specific field in my physical file data.

    So right now im trying to make a CLfile that prints out the fields on the SDA fields when i input the field number. For example, i have a customer database which has the fields EMPNO,EMPNAME,COMPNAME ,etc. so by typing the empno (lets say 'A00001' ) in the input field, i want to able to pull the...

    rootlocus5 pointsBadges:
  • Send SMS to phone from iSeries

    How to send a SMS to a mobile phone or a pager from iSeries?

    poojaary85 pointsBadges:
  • AS/400 Data Queues

    Hi all I am new to RPG and AS/400. I want to know, Does data queues are maintained session wise? if yes then if we have allocated memory of e.g. 2GB, then each session will reserve 2GB? if no then (it is like common shared data) how can we manage data queue. If one user wants to clear data queue...

    hunshabbir7920 pointsBadges:
  • Break message with batch job

    Hi all, When I submit a job in batch. I don't get any break message that job was completed successfully or not. I read somewhere that this attribute is set against message queue to send break message or notify etc. I just call my program with SBMJOB CMD(CALL PGM(xxxxx)) it initiated job QBATCH. How...

    hunshabbir7920 pointsBadges:
  • CPYF Command in AS/400

    Hi, I have two files (A,B) with different definitions (Column names,data type,length etc) are different. Both are on same AS/400 system. Now I want to copy all the records from FILEA to FILEB. What I want to say is, COPY data from one file to another file, where nothing is common in between them....

    HABBIE805 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