compare physical file
can any one tell me how to compare two phisical files in AS400? Can it be done thrugh some query statement?
Answer Question
| June 20, 2012 3:36 PM
AS/400, AS400 physical file
can any one tell me how to compare two phisical files in AS400? Can it be done thrugh some query statement?
Answer Question
| June 20, 2012 3:36 PM
AS/400, AS400 physical file
Month names between 2 numeric Cymd format dates
hi, Hi, I have 2 Numeric field which has cymd date format Date1 7s 0 Date2 7s 0 date1 = 1110128 ( which is 2011-01-28 : January) date2 = 1120101 (which is 2012-01-01 ;January) So what i need is , I need to write records in a file , what are all the months inbetween these [...]
Answer Question
| June 24, 2012 2:28 PM
AS/400, RPGLE
hi, Hi, I have 2 Numeric field which has cymd date format Date1 7s 0 Date2 7s 0 date1 = 1110128 ( which is 2011-01-28 : January) date2 = 1120101 (which is 2012-01-01 ;January) So what i need is , I need to write records in a file , what are all the months inbetween these [...]
Answer Question
| June 24, 2012 2:28 PM
AS/400, RPGLE
Array file and run time arrays
Hi all, Can anybody tell me what is array file in F-spec, and how we declare run time arrays in D-spec and how we specify array file in I-spec ? can we declare externally discribed file as array file in F-spec. Please clarify me with examples.
Answer Question
| June 20, 2012 6:29 AM
AS/400, RPG
Hi all, Can anybody tell me what is array file in F-spec, and how we declare run time arrays in D-spec and how we specify array file in I-spec ? can we declare externally discribed file as array file in F-spec. Please clarify me with examples.
Answer Question
| June 20, 2012 6:29 AM
AS/400, RPG
query
hello sir, I am using STRQRY while using saw “Define report breaks”. what is meaning of Define report breaks? and how we used this ?
Answer Question
| June 20, 2012 10:45 AM
AS/400
hello sir, I am using STRQRY while using saw “Define report breaks”. what is meaning of Define report breaks? and how we used this ?
Answer Question
| June 20, 2012 10:45 AM
AS/400
Storing HTML in a Physical File
Hello everyone, I’m looking for ideas for the best practice of storing HTML in a Physical File (PF). - A huge character field with VARLEN? - Some other data type available in DDS? Can’t describe the PF with SQL (I’d like to, but need to use DDS). Thanks in advance! Dave
Answer Question
| June 21, 2012 2:40 PM
Database, DDS, HTML, PF, System i
Hello everyone, I’m looking for ideas for the best practice of storing HTML in a Physical File (PF). - A huge character field with VARLEN? - Some other data type available in DDS? Can’t describe the PF with SQL (I’d like to, but need to use DDS). Thanks in advance! Dave
Answer Question
| June 21, 2012 2:40 PM
Database, DDS, HTML, PF, System i
Doubt regarding ASP% in AS/400
How can i get detials of ASP% for suppose a couple hours back. and how find which job currently running is increasing the ASP ?….
Answer Question
| June 20, 2012 7:10 PM
AS/400, ASP
How can i get detials of ASP% for suppose a couple hours back. and how find which job currently running is increasing the ASP ?….
Answer Question
| June 20, 2012 7:10 PM
AS/400, ASP
Script to bring down multiple SBS on multiple LPAR’s
I’m wanting to write script(s) where multiple (V6R1)LPAR’s will have different SBS’s brought down, ROBOT, JDE applications brought down, and SQL packages deleted. Once verified all brought down cleanly, another script(s) will bring them all back up on their perspective LPAR’s cleanly. Of course I will be notified of any issues where recycle isn’t working correctly… [...]
Answer Question
| June 20, 2012 8:18 PM
AS/400 scripts, V6R1
I’m wanting to write script(s) where multiple (V6R1)LPAR’s will have different SBS’s brought down, ROBOT, JDE applications brought down, and SQL packages deleted. Once verified all brought down cleanly, another script(s) will bring them all back up on their perspective LPAR’s cleanly. Of course I will be notified of any issues where recycle isn’t working correctly… [...]
Answer Question
| June 20, 2012 8:18 PM
AS/400 scripts, V6R1
AS400 and BOXIR3.1 connectivity
Hi guys, Can anybody tell if Business object can be connected to AS400? Thanks Pranav Sharma
Answer Question
| June 18, 2012 2:15 PM
as400/DB2, Business Objects XI
Hi guys, Can anybody tell if Business object can be connected to AS400? Thanks Pranav Sharma
Answer Question
| June 18, 2012 2:15 PM
as400/DB2, Business Objects XI
Determine who’s running the job
Hi All, I would like to know how can we trace who run the program (person/job/program) running under batch. My question may seem confusing but, I would like to trace who runs a program, what time it was executed and what triggers this. What I can only see is that this job is running under [...]
Answer Question
| June 15, 2012 1:03 AM
iSeries, iSeries data center, iSeries RPG programming
Hi All, I would like to know how can we trace who run the program (person/job/program) running under batch. My question may seem confusing but, I would like to trace who runs a program, what time it was executed and what triggers this. What I can only see is that this job is running under [...]
Answer Question
| June 15, 2012 1:03 AM
iSeries, iSeries data center, iSeries RPG programming
File transfer
I would like to get the AS400 data into text file with no spaces between the fileds. Is there any way to do that?
Answer Question
| June 15, 2012 5:51 AM
AS/400 data transfer
I would like to get the AS400 data into text file with no spaces between the fileds. Is there any way to do that?
Answer Question
| June 15, 2012 5:51 AM
AS/400 data transfer
How to know which program uses a particular module?
Consider I have a module, and I have made some change to the module, (not a parameter change, but just a logic change). Now I have to update all the programs which uses this module. Without the help of any external tools or APIs is there any AS400 command similar to DSPPGMREF which will let [...]
Answer Question
| June 14, 2012 4:45 AM
AS/400, AS/400 commands
Consider I have a module, and I have made some change to the module, (not a parameter change, but just a logic change). Now I have to update all the programs which uses this module. Without the help of any external tools or APIs is there any AS400 command similar to DSPPGMREF which will let [...]
Answer Question
| June 14, 2012 4:45 AM
AS/400, AS/400 commands
Saving LF/PF to Tape
I’m trying to save the LF……but i’m not sure..so just tired in Google but Couldn’t get any good result for saving a LF/PF to a tape. Can any body explain me how to save Logical file and Physical files individually to a tape volume? like saving LF to MEDIA1 and saving PF to MEDIA2?
Answer Question
| June 19, 2012 3:17 AM
AS/400, logical file and Physical File
I’m trying to save the LF……but i’m not sure..so just tired in Google but Couldn’t get any good result for saving a LF/PF to a tape. Can any body explain me how to save Logical file and Physical files individually to a tape volume? like saving LF to MEDIA1 and saving PF to MEDIA2?
Answer Question
| June 19, 2012 3:17 AM
AS/400, logical file and Physical File
Retrieving Subfile Size in RPGLE
Hi Is there any way for us to retrieve subfile size in RPGLE code instead of hard coding it by seeing from the display file. -Vivek
Answer Question
| June 14, 2012 4:08 PM
RPG ILE, Subfile Size
Hi Is there any way for us to retrieve subfile size in RPGLE code instead of hard coding it by seeing from the display file. -Vivek
Answer Question
| June 14, 2012 4:08 PM
RPG ILE, Subfile Size
Service program can be deleted after having a reference to the Service program?
I have a program which refer to a service program, now if the service program gets deleted,any impact? I know a module obj can be deleted after we create a program from that module as it is bind by copy. But since the service program is a bind by reference, will that delete cause any [...]
Answer Question
| June 14, 2012 10:52 AM
Service program
I have a program which refer to a service program, now if the service program gets deleted,any impact? I know a module obj can be deleted after we create a program from that module as it is bind by copy. But since the service program is a bind by reference, will that delete cause any [...]
Answer Question
| June 14, 2012 10:52 AM
Service program
BRMS Select Device (Q1ASLTDEV) API
Hello, I found in the BRMS manual that the BRMS select device API lets you select a device to allocate or deallocate, or to select search values such as location and media class to locate and allocate an available device for BRMS media input or output operations. Well, I don’t understand very well how and [...]
Answer Question
| June 13, 2012 10:24 AM
API, BRMS
Hello, I found in the BRMS manual that the BRMS select device API lets you select a device to allocate or deallocate, or to select search values such as location and media class to locate and allocate an available device for BRMS media input or output operations. Well, I don’t understand very well how and [...]
Answer Question
| June 13, 2012 10:24 AM
API, BRMS
AS/400 Domino Backups.
At times backup hangs up with message as Backup failed due to Pointer not set for location referenced. Backup waits in JobQ and it is not getting in Media library. Kindly help
Answer Question
| June 13, 2012 8:49 AM
AS/400, AS/400 Domino
At times backup hangs up with message as Backup failed due to Pointer not set for location referenced. Backup waits in JobQ and it is not getting in Media library. Kindly help
Answer Question
| June 13, 2012 8:49 AM
AS/400, AS/400 Domino
Initial library
Hi, I would like to create a profile that have 4 initial libraries. How can this be done without changing global system values? or Job descriptions? Thank you
Answer Question
| June 15, 2012 7:03 AM
iSeries, iSeries application development tools, iSeries data center
Hi, I would like to create a profile that have 4 initial libraries. How can this be done without changing global system values? or Job descriptions? Thank you
Answer Question
| June 15, 2012 7:03 AM
iSeries, iSeries application development tools, iSeries data center
RCLSTG MCH4429
I need to run RCLSTG *DBXREF, but receive MCH4429 which ends the job abnormally. I have run RCLSTG before with no issues. Can anyone tell me why this may be happening and how to fix it? The system is V5R3M5
Answer Question
| June 14, 2012 7:41 PM
AS/400, iSeries
I need to run RCLSTG *DBXREF, but receive MCH4429 which ends the job abnormally. I have run RCLSTG before with no issues. Can anyone tell me why this may be happening and how to fix it? The system is V5R3M5
Answer Question
| June 14, 2012 7:41 PM
AS/400, iSeries
How can i search spool files fast?
my user have so many spool files that are not been deleted. i was wondering if there is a way to search for a specific file or a different way for me to search? i only use the page up and down to see everything.
Answer Question
| June 12, 2012 6:34 PM
AS/400 Reports
my user have so many spool files that are not been deleted. i was wondering if there is a way to search for a specific file or a different way for me to search? i only use the page up and down to see everything.
Answer Question
| June 12, 2012 6:34 PM
AS/400 Reports
