1
Using pointers
I need to update a lot of fields in a record testing on an internal array if that field is “updatable”. This should be: FILEFIELD001 = DSFIELD001 for each updatable field. I wonder if could be possible to use pointers to change values in a record and then update that record? In other words, instead [...]
Answer Question
| May 13, 2013 9:53 AM
AS/400, AS/400 Fields, Pointers
I need to update a lot of fields in a record testing on an internal array if that field is “updatable”. This should be: FILEFIELD001 = DSFIELD001 for each updatable field. I wonder if could be possible to use pointers to change values in a record and then update that record? In other words, instead [...]
Date conversion
I have a character field wISODate of length 8A. It holds value in the form of yyyymmdd. I want to convert this to an ISO date field. Decclaration D wDAte S D D wISODate S 8A Assume wISODate has value ’20121001′ *YMD0 Move wISODate wDAte Any other better method is there instead of using Move?
Answer Question
| April 18, 2013 6:00 AM
AS/400, AS/400 Fields
I have a character field wISODate of length 8A. It holds value in the form of yyyymmdd. I want to convert this to an ISO date field. Decclaration D wDAte S D D wISODate S 8A Assume wISODate has value ’20121001′ *YMD0 Move wISODate wDAte Any other better method is there instead of using Move?
About EVAL OPCODE
I have a field which is declared as alphanumeric and the default value for the variable is blank. Now I have declared one more variable which is of zoned decimal type. Now I want to move the value in the alphanumeric variable which is blank into the field, which is declared as zoned decimal. Will [...]
Answer Question
| March 21, 2013 11:01 AM
AS/400, AS/400 Fields
I have a field which is declared as alphanumeric and the default value for the variable is blank. Now I have declared one more variable which is of zoned decimal type. Now I want to move the value in the alphanumeric variable which is blank into the field, which is declared as zoned decimal. Will [...]
How to change fields from one type to another type in display file
I created one display file and declare numeric field as output i.e +6(10).please tell me how to change that field from output to input&output i.e +9(10).
Answer Question
| January 14, 2013 10:30 AM
AS/400, AS/400 Fields
I created one display file and declare numeric field as output i.e +6(10).please tell me how to change that field from output to input&output i.e +9(10).
AS/400 Source. Physical Files. Key Fields?
We assume that we have a source physical file from AS/400 about i.e. Amounts. Is there a way to figure out the key fields?
Answer Question
| March 17, 2012 10:29 AM
AS/400, AS/400 Fields, as/400 files
We assume that we have a source physical file from AS/400 about i.e. Amounts. Is there a way to figure out the key fields?
AS/400 field modification impact on other related objects
I have a file field which we are planning to expand. The same field name is used in some of the files, DSPF’s and PRTF’s. If a program A has this impacted file declared, how can I find the other objects which are impacted due to this modification?
Answer Question
| January 6, 2011 4:15 AM
AS/400 database, AS/400 Fields, DSPF, PRTF
I have a file field which we are planning to expand. The same field name is used in some of the files, DSPF’s and PRTF’s. If a program A has this impacted file declared, how can I find the other objects which are impacted due to this modification?
AS/400 file field usage
is there a way to determine what fields of a file are used in an RPG and CLP program?
Answer Question
| December 20, 2010 3:39 PM
AS/400 Fields, AS/400 file field usage, CLP, CLPROGRAM, RPG Program
is there a way to determine what fields of a file are used in an RPG and CLP program?
Find the Field Name in AS/400
When viewing the screen how can I see what the data field name is? I am looking at the customer master screen, I see field I enter in cert# how can I find on the screen I am looking at what that field name is and what file it belongs to?
Answer Question
| November 15, 2011 3:47 PM
AS/400 Fields, AS/400 Windows, AS400 Data Definitions, Field names
When viewing the screen how can I see what the data field name is? I am looking at the customer master screen, I see field I enter in cert# how can I find on the screen I am looking at what that field name is and what file it belongs to?
Trimming leading zeros in as/400
Hi, I have a character input parameter of length 8. I have a customer number which may vary according to a query that user enters. This customer number is searched in an input file where the key field is numeric. I want to change this input parameter to numeric without any trailing zeros/blanks. Anyone who [...]
Answer Question
| June 18, 2010 8:17 AM
AS/400 Fields, OS/400, RPG Code
Hi, I have a character input parameter of length 8. I have a customer number which may vary according to a query that user enters. This customer number is searched in an input file where the key field is numeric. I want to change this input parameter to numeric without any trailing zeros/blanks. Anyone who [...]
FIELD EXPANSION PROJECT AS400
Hi, Would like to know if anyone has carried out Field Expansion Project on AS400. I would like to know strategies, tools used for FIELDS AT RISK IN DATABASE. I know about tools for Field Expansion, but want to know about Identifying the Fields at Risk
Answer Question
| March 2, 2011 12:13 PM
AS/400 Fields
Hi, Would like to know if anyone has carried out Field Expansion Project on AS400. I would like to know strategies, tools used for FIELDS AT RISK IN DATABASE. I know about tools for Field Expansion, but want to know about Identifying the Fields at Risk
AS/400 date format
How do format a date field to MM/DD/YYYY?
Answer Question
| April 16, 2009 1:57 PM
AS/400 date format, AS/400 Fields, AS/400 queries
How do format a date field to MM/DD/YYYY?
1





