OUTQ
Whenever a job is started, an OUTQ is assigned and stays with the job until the job ends or a CHGJOB command is executed. On the SBMJOB command you have 4 options that can be specified for the OUTQ: *CURRENT *USRPRF *DEV *JOBD
View Answer
| December 22, 2011 2:26 PM
OUTQ, outqueue
Whenever a job is started, an OUTQ is assigned and stays with the job until the job ends or a CHGJOB command is executed. On the SBMJOB command you have 4 options that can be specified for the OUTQ: *CURRENT *USRPRF *DEV *JOBD
View Answer
| December 22, 2011 2:26 PM
OUTQ, outqueue
snddst- in RPG
Are you properly combining the addresses is the command? If you prompt it (F4), that should set it all up for you. I don’t have a BCC example, but I do have an example of sending to multiple addresses: <pre> snddst type(*doc) tointnet((user1@domain.com *pri) + (user2@domain.com *pri)) dstd(‘Blah + Blah Blah’) msg(‘Yada Yada + Yada’) [...]
View Answer
| December 22, 2011 2:22 PM
AS/400 email, RPG ILE, RPGLE, SNDDST
Are you properly combining the addresses is the command? If you prompt it (F4), that should set it all up for you. I don’t have a BCC example, but I do have an example of sending to multiple addresses: <pre> snddst type(*doc) tointnet((user1@domain.com *pri) + (user2@domain.com *pri)) dstd(‘Blah + Blah Blah’) msg(‘Yada Yada + Yada’) [...]
View Answer
| December 22, 2011 2:22 PM
AS/400 email, RPG ILE, RPGLE, SNDDST
write physical file member using RPGLE program
i got the answer for write record in physical file member i shared that concept coding…. Femp1 uf a e k disk usropn extmbr(a3) — emp1 -> pf name Da3 s 10a C eval a3=’EMP12′ — emp12 -> pf member name C open emp1 C write employee — employee – pf record format name C [...]
View Answer
| December 22, 2011 1:38 PM
RPGLE Program
i got the answer for write record in physical file member i shared that concept coding…. Femp1 uf a e k disk usropn extmbr(a3) — emp1 -> pf name Da3 s 10a C eval a3=’EMP12′ — emp12 -> pf member name C open emp1 C write employee — employee – pf record format name C [...]
View Answer
| December 22, 2011 1:38 PM
RPGLE Program
usage of figurative constant *loval with Setll
when you assigned k field. it access the record using keyed sequence access path.. but if you didn’t assign k field. it doesn’t consider key field while record accessing.. just try like this: Filename if e disk recno(var1) var1 s p 0 inz(1) var1 setll Filename use recno keyword in F -spc…
View Answer
| December 22, 2011 9:57 AM
AS/400, AS400 RPGLE, Settl *loval usage
when you assigned k field. it access the record using keyed sequence access path.. but if you didn’t assign k field. it doesn’t consider key field while record accessing.. just try like this: Filename if e disk recno(var1) var1 s p 0 inz(1) var1 setll Filename use recno keyword in F -spc…
View Answer
| December 22, 2011 9:57 AM
AS/400, AS400 RPGLE, Settl *loval usage
how to handle Cursor progression in a mixed display file
You need to use the FLDCSRPRG : OK, so in SDA place * against the “from date” field and take the “General Keywords” option. Against FLDCSRPRG enter the field you want the cursor to go to after this field. In this case the “to date” field. You can do this against all fields. Neil.
View Answer
| December 22, 2011 9:12 AM
DSPF, FLDCSPPRG, Subfile Control, Subfile Display
You need to use the FLDCSRPRG : OK, so in SDA place * against the “from date” field and take the “General Keywords” option. Against FLDCSRPRG enter the field you want the cursor to go to after this field. In this case the “to date” field. You can do this against all fields. Neil.
View Answer
| December 22, 2011 9:12 AM
DSPF, FLDCSPPRG, Subfile Control, Subfile Display
FTP & SAVF
<i>1.How to download a savf to pc from iseries:</i> Start->RUN->FTP your server IP->enter -> enter Username & password next you need changed current library… for that follow my steps… <b>cd /qsys.lib/govin.lib/</b> <b>lcd d:sp</b> <b>bin </b> -> to change binary image <b>get sav1.savf</b> -> after 5 min it ll show file transfer completed successfully.. <b>quit</b>… <i>2.How [...]
View Answer
| December 22, 2011 8:09 AM
AS/400, FTP, SAVF
<i>1.How to download a savf to pc from iseries:</i> Start->RUN->FTP your server IP->enter -> enter Username & password next you need changed current library… for that follow my steps… <b>cd /qsys.lib/govin.lib/</b> <b>lcd d:sp</b> <b>bin </b> -> to change binary image <b>get sav1.savf</b> -> after 5 min it ll show file transfer completed successfully.. <b>quit</b>… <i>2.How [...]
View Answer
| December 22, 2011 8:09 AM
AS/400, FTP, SAVF
How to get the list of files in a library to a outfile
use DSPOBJD command for <i>list of *file of attribute PF in a library in an outfile</i>…. Object . . . . . . . . . . . . . > *ALL Library . . . . . . . . . . . > Libname Object type . . . . . . . [...]
View Answer
| December 21, 2011 10:49 AM
DSPOBJD, MS
use DSPOBJD command for <i>list of *file of attribute PF in a library in an outfile</i>…. Object . . . . . . . . . . . . . > *ALL Library . . . . . . . . . . . > Libname Object type . . . . . . . [...]
View Answer
| December 21, 2011 10:49 AM
DSPOBJD, MS
Is anyone user Mantis/400 bug tracker / help desk software?
My company use iKode helpdesk x, which is a web based <a href=”http://www.phphelpdesk.org/”>help desk software</a>.
View Answer
| December 21, 2011 9:28 AM
AS/400, i5/OS, I5/OS updates, Mantis400, Zend
My company use iKode helpdesk x, which is a web based <a href=”http://www.phphelpdesk.org/”>help desk software</a>.
View Answer
| December 21, 2011 9:28 AM
AS/400, i5/OS, I5/OS updates, Mantis400, Zend
CPF Errors
The both error id is “global” error messsage, used to trap all messages. When you use MONMSG for CPF0000, you are looking for any error messages, while a CPF9999 is for function checks. When you implement a program-level message monitor, I recommend that you use the message identifier CPF9999 instead of the widely used CPF0000. [...]
View Answer
| December 21, 2011 6:49 AM
CPF errors, CPF0000, CPF9999
The both error id is “global” error messsage, used to trap all messages. When you use MONMSG for CPF0000, you are looking for any error messages, while a CPF9999 is for function checks. When you implement a program-level message monitor, I recommend that you use the message identifier CPF9999 instead of the widely used CPF0000. [...]
View Answer
| December 21, 2011 6:49 AM
CPF errors, CPF0000, CPF9999
what does SQL, DDS mean in Generation mode?
I would assume it means you are using SQL to create a table(file), and theSQL instructions are in a source member. (Probably QDDSSRC). The table is created with a RUNSQLSTM Something like this for the source member: <pre> CREATE TABLE SPDLVCTL (Credit_Union_Number for CUNO CHAR (04) Not Null with Default, Delivery_Type for DLVTYPE CHAR (03) [...]
View Answer
| December 19, 2011 5:12 PM
Synon, SYNON COOL2E
I would assume it means you are using SQL to create a table(file), and theSQL instructions are in a source member. (Probably QDDSSRC). The table is created with a RUNSQLSTM Something like this for the source member: <pre> CREATE TABLE SPDLVCTL (Credit_Union_Number for CUNO CHAR (04) Not Null with Default, Delivery_Type for DLVTYPE CHAR (03) [...]
View Answer
| December 19, 2011 5:12 PM
Synon, SYNON COOL2E
CPYFRMIMPF error
gave the single quotation ( ‘ ) properly in from and to path field… check and matched the case of the file name….and object type…. and refer this link <a href=”http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/cl/cpyfrmst.htm?notoc”>Copy from Stream File</a>
View Answer
| December 19, 2011 3:58 PM
CPYFRMIMPF
gave the single quotation ( ‘ ) properly in from and to path field… check and matched the case of the file name….and object type…. and refer this link <a href=”http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/cl/cpyfrmst.htm?notoc”>Copy from Stream File</a>
View Answer
| December 19, 2011 3:58 PM
CPYFRMIMPF
Command function
The Start PC Command (STRPCCMD) command allows you to run a single application, a DOS command, or an OS/2 command on an attached personal computer. The Start Client Access Organizer (STRPCO) command starts the Client Access Organizer on the host system. Note: The STRPCO CL command must be issued before running the STRPCCMD CL command. [...]
View Answer
| December 19, 2011 8:53 AM
AS/400, Command function, STRPCCMD command
The Start PC Command (STRPCCMD) command allows you to run a single application, a DOS command, or an OS/2 command on an attached personal computer. The Start Client Access Organizer (STRPCO) command starts the Client Access Organizer on the host system. Note: The STRPCO CL command must be issued before running the STRPCCMD CL command. [...]
View Answer
| December 19, 2011 8:53 AM
AS/400, Command function, STRPCCMD command
AS/400
Hi Sameer, What would you need to do exactly? Do you need to Delete Some file at End of Day Script Processing? Or Do you need to Remove Some Data files from End of Day Script? Generally, Across all AS/400 Systems, There will End of Day(or Week) Processing. Which will update the Database Files(Based on [...]
View Answer
| December 19, 2011 7:46 AM
AS/400, as/400 data
Hi Sameer, What would you need to do exactly? Do you need to Delete Some file at End of Day Script Processing? Or Do you need to Remove Some Data files from End of Day Script? Generally, Across all AS/400 Systems, There will End of Day(or Week) Processing. Which will update the Database Files(Based on [...]
View Answer
| December 19, 2011 7:46 AM
AS/400, as/400 data
Restoration
If your System Administrators are taking backup into tapes for your application, Then you should request for the most recent tape and Restore the objects from tape. RSTOBJ command will help you in this regard. <pre> Restore Object (RSTOBJ) Type choices, press Enter. Objects . . . . . . . . . . . [...]
View Answer
| December 19, 2011 7:21 AM
AS/400, as400 file restoration, Restoration
If your System Administrators are taking backup into tapes for your application, Then you should request for the most recent tape and Restore the objects from tape. RSTOBJ command will help you in this regard. <pre> Restore Object (RSTOBJ) Type choices, press Enter. Objects . . . . . . . . . . . [...]
View Answer
| December 19, 2011 7:21 AM
AS/400, as400 file restoration, Restoration
Forcing data to stay left going to excel
You need to write the value of the 1st cell 123 with a quote mark ‘ in the first position with the data concatenated after that. This will make excel think it is a alpha field and left justify it,
View Answer
| December 16, 2011 4:00 PM
AS400 RPGLE, AS400 RPGLE .CSV
You need to write the value of the 1st cell 123 with a quote mark ‘ in the first position with the data concatenated after that. This will make excel think it is a alpha field and left justify it,
View Answer
| December 16, 2011 4:00 PM
AS400 RPGLE, AS400 RPGLE .CSV
extract data from as400 to excel
Here is some code to send an email of a file in .csv format. It is a stripped down verion of a command I wrote. It will sent the complete file. I you only want to send selected records, create a file using some records selection process: LF, CPYF, QRY, SQL. etc <pre> PGM PARM(&pFileIn) [...]
View Answer
| December 16, 2011 2:55 PM
AS/400 File Extract, excel
Here is some code to send an email of a file in .csv format. It is a stripped down verion of a command I wrote. It will sent the complete file. I you only want to send selected records, create a file using some records selection process: LF, CPYF, QRY, SQL. etc <pre> PGM PARM(&pFileIn) [...]
View Answer
| December 16, 2011 2:55 PM
AS/400 File Extract, excel
how to set lower and higher records in CLLE
There is no Paticular Opcode in CL for Reading Lower and Higher Record. But, You can do this by Ordering the File in Required Order using OPNQRYF. Eg:- If you want to Read the lower Record, You will need to create the logical view for the file in Ascending order of key field. <pre>OPNQRYF FILE(TESTPF) [...]
View Answer
| December 16, 2011 12:24 PM
as400 v5r3, CLLE, CLLE - Opnqryf
There is no Paticular Opcode in CL for Reading Lower and Higher Record. But, You can do this by Ordering the File in Required Order using OPNQRYF. Eg:- If you want to Read the lower Record, You will need to create the logical view for the file in Ascending order of key field. <pre>OPNQRYF FILE(TESTPF) [...]
View Answer
| December 16, 2011 12:24 PM
as400 v5r3, CLLE, CLLE - Opnqryf
Read a source physical file
Would you like to get all the Files present in a particular Library? Source Physical file doesnt contain the list of Files(Objects) in it. But, It will store the Source of a File or Program as Members. If you declare Source Physical file using CL and if you try to Read the file, You can [...]
View Answer
| December 16, 2011 10:19 AM
AS/400, DCLF, dclf statement
Would you like to get all the Files present in a particular Library? Source Physical file doesnt contain the list of Files(Objects) in it. But, It will store the Source of a File or Program as Members. If you declare Source Physical file using CL and if you try to Read the file, You can [...]
View Answer
| December 16, 2011 10:19 AM
AS/400, DCLF, dclf statement
Job sites
http://www.indeed.co.in http://www.computerjobs.com
View Answer
| December 16, 2011 5:23 AM
AS/400 careers, AS/400 jobs, IT careers, IT jobs
http://www.indeed.co.in http://www.computerjobs.com
View Answer
| December 16, 2011 5:23 AM
AS/400 careers, AS/400 jobs, IT careers, IT jobs
Lost License Key After IPL
It sounds like … but of course may not be … that you never entered the IBM i license key successfully. Most products (BRMS, WDS, PT1, QU1) will cease to function after 70 days if the license key is not entered, but the base OS environment (5770SS1 5050) will run past 70 days until the [...]
View Answer
| December 16, 2011 12:52 AM
iseries v5r4
It sounds like … but of course may not be … that you never entered the IBM i license key successfully. Most products (BRMS, WDS, PT1, QU1) will cease to function after 70 days if the license key is not entered, but the base OS environment (5770SS1 5050) will run past 70 days until the [...]
View Answer
| December 16, 2011 12:52 AM
iseries v5r4
