what does SQL, DDS mean in Generation mode?
what does SQL, DDS mean in Generation mode in an Access path in SYNON
Answer Question
| March 17, 2012 3:55 PM
Synon, SYNON COOL2E
what does SQL, DDS mean in Generation mode in an Access path in SYNON
CPYFRMIMPF error
Receiving this error message “File system error occurred. Error number 3025. Copy command ended because of error.” Any suggestions
Answer Question
| March 17, 2012 2:03 PM
CPYFRMIMPF
Receiving this error message “File system error occurred. Error number 3025. Copy command ended because of error.” Any suggestions
Command function
Explain the function of STRPCCMD command in AS400??
Answer Question
| March 17, 2012 7:36 AM
AS/400, Command function, STRPCCMD command
Explain the function of STRPCCMD command in AS400??
AS/400
How can i delete the datafiles within endofday script
Answer Question
| March 17, 2012 7:34 AM
AS/400, as/400 data
How can i delete the datafiles within endofday script
Restoration
Is it possible to restore the deleted objects in AS400?plz guide me??
Answer Question
| March 17, 2012 7:12 AM
AS/400, as400 file restoration, Restoration
Is it possible to restore the deleted objects in AS400?plz guide me??
Auto Refresh page with server time counting in RPGLE program
I successfully completed auto refresh page with server time counting in RPGLE program. While run my program, some times i got the below error… I/O error CPF4737 was detected in file AUTODSP (C G D F). i share my display coding and rpgle coding below Display file coding.. A [...]
Answer Question
| March 17, 2012 7:01 AM
RPGLE Program
I successfully completed auto refresh page with server time counting in RPGLE program. While run my program, some times i got the below error… I/O error CPF4737 was detected in file AUTODSP (C G D F). i share my display coding and rpgle coding below Display file coding.. A [...]
Web query options not displayed
I am working through the Redbook on Web Query. I have logged on as an administrator through the browser and created a new domain. Next step is to create metadata and that should be accessed via a drop down menu on the reports folder. The only options I have when I right click the reports [...]
Answer Question
| March 19, 2012 6:57 AM
iSeries, iseries v5r4, web query
I am working through the Redbook on Web Query. I have logged on as an administrator through the browser and created a new domain. Next step is to create metadata and that should be accessed via a drop down menu on the reports folder. The only options I have when I right click the reports [...]
Forcing data to stay left going to excel
InLot Contains 123 ABC456 Eval outlot = inlot transfer file to .csv outlot ‘ 123′ ‘ABC456 ‘ Ugly. How do I force it to all stay to the left. TrimL, MoveL has no effect. It is in the translation to .csv. Thanks, Nick
Answer Question
| March 17, 2012 3:52 PM
AS400 RPGLE, AS400 RPGLE .CSV
InLot Contains 123 ABC456 Eval outlot = inlot transfer file to .csv outlot ‘ 123′ ‘ABC456 ‘ Ugly. How do I force it to all stay to the left. TrimL, MoveL has no effect. It is in the translation to .csv. Thanks, Nick
how to set lower and higher records in CLLE
i want to set lower and higher records value using CLLE program…. or read first record and last record in cl….
Answer Question
| February 28, 2012 11:39 AM
as400 v5r3, CLLE, CLLE - Opnqryf
i want to set lower and higher records value using CLLE program…. or read first record and last record in cl….
FILES
is it possible to read records without declaring file in F-spec?
Answer Question
| March 19, 2012 10:32 AM
AS/400, F Spec, RPG Program
is it possible to read records without declaring file in F-spec?
Read a source physical file
Is there any way to declare all the files present in a source physical file using CL by the single DCLF statement?
Answer Question
| February 28, 2012 9:43 AM
AS/400, DCLF, dclf statement
Is there any way to declare all the files present in a source physical file using CL by the single DCLF statement?
extract data from as400 to excel
I have CL and DB files and i need to extract the data from the files to excel sheet by writing an program.How can i do that?
Answer Question
| March 17, 2012 8:17 AM
AS/400 File Extract, excel
I have CL and DB files and i need to extract the data from the files to excel sheet by writing an program.How can i do that?
Job sites
May i know the important job sites for AS400 jobs?
Answer Question
| March 17, 2012 4:52 AM
AS/400 careers, AS/400 jobs, IT careers, IT jobs
May i know the important job sites for AS400 jobs?
Lost License Key After IPL
We have not IPL the system in over a year. Upon doing so we lost the license key. How could this issue happen. We only IPL the system , we made no changes. System V5R4
Answer Question
| March 17, 2012 2:54 PM
iseries v5r4
We have not IPL the system in over a year. Upon doing so we lost the license key. How could this issue happen. We only IPL the system , we made no changes. System V5R4
iSeries cache
Is there a way to clear the memory cache in iSeries system?
Answer Question
| February 28, 2012 11:39 AM
Cache, iSeries
Is there a way to clear the memory cache in iSeries system?
Find the Source file
Which command is used to identify the source physical file and Library of an object?
Answer Question
| March 17, 2012 6:32 AM
AS/400
Which command is used to identify the source physical file and Library of an object?
OPNQRYF
Can we update physical file through OPNQRYF command in clle (AS400)??Is it possible???plz guide me?? Through his option what we can do?? OPNQRYF FILE((lib/pf)) OPTION(*UPD) QRYSLT(‘CDE + *EQ 101 ‘) KEYFLD((CDE))
Answer Question
| March 17, 2012 5:44 AM
OPNQRYF
Can we update physical file through OPNQRYF command in clle (AS400)??Is it possible???plz guide me?? Through his option what we can do?? OPNQRYF FILE((lib/pf)) OPTION(*UPD) QRYSLT(‘CDE + *EQ 101 ‘) KEYFLD((CDE))
How secure is the Electronic Service Agent
Since data is confidential on every iSeries, how would we know if the data sent to IBM is only about error and performance logs and no data is being sent to IBM servers? What profile is used to send this logs and does it have authority over data/user libraries? Thank you
Answer Question
| March 17, 2012 5:16 AM
iSeries, iSeries applications, iSeries data center, iSeries networking, iSeries RPG programming
Since data is confidential on every iSeries, how would we know if the data sent to IBM is only about error and performance logs and no data is being sent to IBM servers? What profile is used to send this logs and does it have authority over data/user libraries? Thank you
CL script required for tape automation process
Hi All, allocated with LT04 tape unit in the physical 3584 tape library. The following scenarios to test: • Tape properly loaded • Improperly loaded • No tape • Incorrect Category • Aborted, try to restart. CL script required for tape automation process to check the above 5 scenarios. Any help will be appreciated. Thanks [...]
Answer Question
| February 28, 2012 3:36 PM
AS/400 - DDS, AS/400 backup, AS/400 BRMS, AS/400 hardware, AS/400 programming
Hi All, allocated with LT04 tape unit in the physical 3584 tape library. The following scenarios to test: • Tape properly loaded • Improperly loaded • No tape • Incorrect Category • Aborted, try to restart. CL script required for tape automation process to check the above 5 scenarios. Any help will be appreciated. Thanks [...]





