Search for text within a string in CL/400
Wath function can I use to find a text into other? I mean how caon I find the Position for -B- in the text -AABAA-
Wath function can I use to find a text into other? I mean how caon I find the Position for -B- in the text -AABAA-
5 pts.
How to access all records in RPGILE
hi all, suppose i have a report with input criteria 'machine code' and requirement it that if i input a perticular 'machine code' then it should COME only that , otherwise all records of all 'machine codes' should come , in clp i use %WLDCRD for that. but i need to do it in rpgile , is there any...
hi all, suppose i have a report with input criteria 'machine code' and requirement it that if i input a perticular 'machine code' then it should COME only that , otherwise all records of all 'machine codes' should come , in clp i use %WLDCRD for that. but i need to do it in rpgile , is there any...
How to get the row count of a PF with RPG ILE?
Hello, I'm looking for an example of how to get a row count of a PF from a ILE rpg program. Thanks everybody.
Hello, I'm looking for an example of how to get a row count of a PF from a ILE rpg program. Thanks everybody.
RUMBA macro to append data
Hello, I am a new user to the RUMBA AS400 client. I am trying to make a macro that appends all the data that is copied. But i can not find an option for it. I have found copy all but i can not make the keystrokes to use the append data feature. If someone knows the answer i would greatly...
Hello, I am a new user to the RUMBA AS400 client. I am trying to make a macro that appends all the data that is copied. But i can not find an option for it. I have found copy all but i can not make the keystrokes to use the append data feature. If someone knows the answer i would greatly...
Make history of stream files in AS/400
Hi, I want to make a history of a Directory in AS400. (Command WRKLNK) for example like this: /EMAIL/WORK Directory WORK consists of stream files (type STMF) organized like this: WRK.001 WRK.002 WRK.003 Etc. On a monthly base I want to move all the stream files older than 1 month to ...
Hi, I want to make a history of a Directory in AS400. (Command WRKLNK) for example like this: /EMAIL/WORK Directory WORK consists of stream files (type STMF) organized like this: WRK.001 WRK.002 WRK.003 Etc. On a monthly base I want to move all the stream files older than 1 month to ...
Changing system request
I wanted to change the system request option 5 from SNDMSG to a command line. So i created a new message file and changed the text in CPX2313 and then i used the command to CHGSYSLIBL to put my lib on top of the libl. But still when i take option 5 on system rqs i get the following error "Command...
I wanted to change the system request option 5 from SNDMSG to a command line. So i created a new message file and changed the text in CPX2313 and then i used the command to CHGSYSLIBL to put my lib on top of the libl. But still when i take option 5 on system rqs i get the following error "Command...
Receiving an XML file to RPG
HI, I need to receive xml files ( of fixed format ) to my rpgle progrm ( not free format RPG ) and do some calculations. Can i do this without purchasing any tools ( free tools can be used). Please let me know if anyone has done something similar Regards, Kiron
HI, I need to receive xml files ( of fixed format ) to my rpgle progrm ( not free format RPG ) and do some calculations. Can i do this without purchasing any tools ( free tools can be used). Please let me know if anyone has done something similar Regards, Kiron
Haversine formula in RPG or SQL
I need to put the haversine formula in an sql or rpg function on the as400 to calc the distance between to zip codes. I do not have much experience with sql. can anyone give me some help?
I need to put the haversine formula in an sql or rpg function on the as400 to calc the distance between to zip codes. I do not have much experience with sql. can anyone give me some help?
Find source member
I am new to as400 i having one object(qap)But i having seven source member.Each source member having more than 500 program. My question how will i find in which source member i having that object(qap).plz answer my question
I am new to as400 i having one object(qap)But i having seven source member.Each source member having more than 500 program. My question how will i find in which source member i having that object(qap).plz answer my question
Decimal Value as a Date
I have an AS/400 field called ADMIT_DATE that is typed DECIMAL(8,0). It contains values such as 20061031. (including the decimal point). I would like to convert that field to an AS/400 DATE field such that the resulting values look like 2006-10-31. Can someone provide an example using the AS/400...
I have an AS/400 field called ADMIT_DATE that is typed DECIMAL(8,0). It contains values such as 20061031. (including the decimal point). I would like to convert that field to an AS/400 DATE field such that the resulting values look like 2006-10-31. Can someone provide an example using the AS/400...
Grouping the records in RPG
How to I group the records in the database based on one particular field?? When i try using a group by clause in the embedded SQL, it give me a 'SQL precompile failed' error. How do I handle this?? And i have to display the employee records grouped by their locations... how can this be done??
How to I group the records in the database based on one particular field?? When i try using a group by clause in the embedded SQL, it give me a 'SQL precompile failed' error. How do I handle this?? And i have to display the employee records grouped by their locations... how can this be done??
Enforce only alphabets in a particular field of physical file
what is the keyword to enforce entry of only alphabets in a particular field of physical file??? for ex: NAME field of EMPLOYEE MASTER.
what is the keyword to enforce entry of only alphabets in a particular field of physical file??? for ex: NAME field of EMPLOYEE MASTER.
How to display the SQL query results on SDA screen?
I got an answer for how to embed the SQL statements in RPG program. Can you please help me with how to use these values in the program, or display them on the SDA screen??? Thank you. :)
I got an answer for how to embed the SQL statements in RPG program. Can you please help me with how to use these values in the program, or display them on the SDA screen??? Thank you. :)
Debug an AS/400 program called from Java
Hi, Is there any way i can hold an AS400 job triggered from java. I need to debug a program which is interactively called from java.
Hi, Is there any way i can hold an AS400 job triggered from java. I need to debug a program which is interactively called from java.
numeric operation is too small to hold the result (C G D F)
HOW TO REMOVE THIS ERROR-"The target for a numeric operation is too small to hold the result (C G D F)"?
View Answer
| Oct 3 2008 5:49 AM GMT
AS/400 errors, AS/400 development, Numeric operation is too small
HOW TO REMOVE THIS ERROR-"The target for a numeric operation is too small to hold the result (C G D F)"?
View Answer
| Oct 3 2008 5:49 AM GMTAS/400 errors, AS/400 development, Numeric operation is too small
How to mirror two databases (PRD to DEV)?
HI, I am trying to mirror my DEV box data lib with Production box. Currently i am creating a save file and then i FTP it to DEV box and restore lib. Any other way to do this? FTP takes a lot of time to transfer so, any suggestions on fast transfers would also be helpful. thanks
HI, I am trying to mirror my DEV box data lib with Production box. Currently i am creating a save file and then i FTP it to DEV box and restore lib. Any other way to do this? FTP takes a lot of time to transfer so, any suggestions on fast transfers would also be helpful. thanks
