CHKIN Command in iseries
What is the use of CHKIN command and where do we use this? i have gone through infocenter but couldn’t understand …… “The Check In Object (CHKIN) command checks in an object that had previously been checked out.” can anybody explain the use of it?
Answer Question
| November 2, 2010 11:11 AM
AS/400, AS/400 command functions, AS/400 commands, iSeries, work management
What is the use of CHKIN command and where do we use this? i have gone through infocenter but couldn’t understand …… “The Check In Object (CHKIN) command checks in an object that had previously been checked out.” can anybody explain the use of it?
Answer Question
| November 2, 2010 11:11 AM
AS/400, AS/400 command functions, AS/400 commands, iSeries, work management
cpyf and cpysplf: How to copy spool files and database files in AS/400?
Hi, Can you give me the what are the steps to copy the data from one pf to another pf using cpyf? and how to copy the data from spool file to database file using cpysplf?
Answer Question
| November 9, 2010 5:12 AM
AS/400 Spool Files, CPYF, CPYSPLF, Database Files, RPG
Hi, Can you give me the what are the steps to copy the data from one pf to another pf using cpyf? and how to copy the data from spool file to database file using cpysplf?
Answer Question
| November 9, 2010 5:12 AM
AS/400 Spool Files, CPYF, CPYSPLF, Database Files, RPG
How do I change the field length in a physical file using chgpf command?
Hi, This is giri.Im looking to change the field length in pf using chgpf command?Please give me what are the steps i have to do?How can i change the field?
Answer Question
| November 3, 2010 5:07 AM
CHGPF, Physical Files, RPG/400
Hi, This is giri.Im looking to change the field length in pf using chgpf command?Please give me what are the steps i have to do?How can i change the field?
Answer Question
| November 3, 2010 5:07 AM
CHGPF, Physical Files, RPG/400
Simulate a key stroke using CL on an AS/400 system?
Just currious, but is there a way to simulate a key stroke like the >enter< key within a cl prog on an as400 system? Thanks.
Answer Question
| November 1, 2010 10:14 AM
AS/400, AS400 iseries, CL Commands, CL programming, Control Language Programming
Just currious, but is there a way to simulate a key stroke like the >enter< key within a cl prog on an as400 system? Thanks.
Answer Question
| November 1, 2010 10:14 AM
AS/400, AS400 iseries, CL Commands, CL programming, Control Language Programming
FTP over SSL from iSeries
Hello, I send FTP over SSL to ten other servers from iSeries. I have loaded all certificates & trusted and it’s working fine. But my question is, How would iSeries system identifies a particular certificate to verify when we do FTP to any one server of ten ? Thanks Sim
Answer Question
| November 5, 2010 4:13 AM
AS/400, FTP, iSeries, iSeries security, Security, SSL
Hello, I send FTP over SSL to ten other servers from iSeries. I have loaded all certificates & trusted and it’s working fine. But my question is, How would iSeries system identifies a particular certificate to verify when we do FTP to any one server of ten ? Thanks Sim
Answer Question
| November 5, 2010 4:13 AM
AS/400, FTP, iSeries, iSeries security, Security, SSL
CL Command definition parameter with Mixed valid values
Hello, I want to create a command with a parameter same as Stream file code page in CPYTOSTMF. It shoud allow only 1 – 32657, *STMF, *PCASCII, *STDASCII. Can someone explain how could I declare parameter to have this ? Thanks Sim
Answer Question
| November 1, 2010 4:09 AM
AS/400, CL, CL Commands, CL Parameters, CPYTOSTMF, Stream files
Hello, I want to create a command with a parameter same as Stream file code page in CPYTOSTMF. It shoud allow only 1 – 32657, *STMF, *PCASCII, *STDASCII. Can someone explain how could I declare parameter to have this ? Thanks Sim
Answer Question
| November 1, 2010 4:09 AM
AS/400, CL, CL Commands, CL Parameters, CPYTOSTMF, Stream files
AS/400 9401-150 SRC stop at: B3154136 ,, FI00010 ,,, F23 …. 2270
This server 9401-150 Advanced Entry V3.R7.M0 was working. Aftrer a power off, at next IPL showed B3154136, analizing the SRC code …FI00010, Function 23, display 2270. That means the System Board MFIOP/Processor, (2270) part 45H2396 as gone to paradise. Is anybody in the world could have such motherboard? Is it possible to recuperate somewhere such [...]
Answer Question
| November 18, 2010 10:49 PM
AS/400, MFIOP, Motherboards, V3R7
This server 9401-150 Advanced Entry V3.R7.M0 was working. Aftrer a power off, at next IPL showed B3154136, analizing the SRC code …FI00010, Function 23, display 2270. That means the System Board MFIOP/Processor, (2270) part 45H2396 as gone to paradise. Is anybody in the world could have such motherboard? Is it possible to recuperate somewhere such [...]
Answer Question
| November 18, 2010 10:49 PM
AS/400, MFIOP, Motherboards, V3R7
as400 client access and okidata printer
How can I get client access allow printer to use printer default settings (i.e.) condensed print — also skipping pages between reports
Answer Question
| October 29, 2010 8:03 PM
AS/400 Client Access, AS/400 printers, AS/400 printing, AS400 printing jobs
How can I get client access allow printer to use printer default settings (i.e.) condensed print — also skipping pages between reports
Answer Question
| October 29, 2010 8:03 PM
AS/400 Client Access, AS/400 printers, AS/400 printing, AS400 printing jobs
How do I INSERT records into AS400 DB2 file from SQL server?
I can pull data from AS400 to SQL but cannot get my command on the SQL server to push the data back. This is a very small process, I only need an item number and date. Also, the date on the SQL db is “datetime”. I’ll need to convert that to a more recognizable date field [...]
Answer Question
| November 3, 2010 3:52 PM
AS/400, DB2/400, SQL Server, SQL Server 2005
I can pull data from AS400 to SQL but cannot get my command on the SQL server to push the data back. This is a very small process, I only need an item number and date. Also, the date on the SQL db is “datetime”. I’ll need to convert that to a more recognizable date field [...]
Answer Question
| November 3, 2010 3:52 PM
AS/400, DB2/400, SQL Server, SQL Server 2005
STRPDM and STRDFU Authority in iSeries
I would like to block all users except the programmers from using either of these commands. I have tried using *Exclude for *Public and it blocks all users with a *USER for user class but does not block the users with a *SYSOPR user class and they are the ones I need to block. Anyone [...]
Answer Question
| November 2, 2010 3:21 PM
i520, STRDFU, STRPDM, V5R3
I would like to block all users except the programmers from using either of these commands. I have tried using *Exclude for *Public and it blocks all users with a *USER for user class but does not block the users with a *SYSOPR user class and they are the ones I need to block. Anyone [...]
Answer Question
| November 2, 2010 3:21 PM
i520, STRDFU, STRPDM, V5R3
Device *REQUESTER not found while opening file
Trying to use a Workstn sfile in Batch. If program is called the Sfile is loaded and allows user to update and then print the information in the subfile. If program is called from batch I want to load the subfile (without displaying) and then print it. Can this be done or will I have [...]
Answer Question
| December 3, 2010 8:44 PM
AS/400, AS/400 batch jobs, AS/400 Subfiles, Batch
Trying to use a Workstn sfile in Batch. If program is called the Sfile is loaded and allows user to update and then print the information in the subfile. If program is called from batch I want to load the subfile (without displaying) and then print it. Can this be done or will I have [...]
Answer Question
| December 3, 2010 8:44 PM
AS/400, AS/400 batch jobs, AS/400 Subfiles, Batch
AS/400 printing HP 4250
how can i print bold on a hp 4250 *AFPDS printer fom the iseries? I am printing a barcode an would like to be able print in bold another field.
Answer Question
| October 29, 2010 7:28 PM
AS/400, AS/400 print jobs, AS/400 printing, HP 4250
how can i print bold on a hp 4250 *AFPDS printer fom the iseries? I am printing a barcode an would like to be able print in bold another field.
Answer Question
| October 29, 2010 7:28 PM
AS/400, AS/400 print jobs, AS/400 printing, HP 4250
AS/400 Journal entry type IZ
Hi, I have a journal entry of type IZ and I was wondering what causes this to be generated? The documentation says it is from an INZPFM command but the program specified on the journal entry does not execute this command.
Answer Question
| October 30, 2010 1:24 PM
AS/400 commands, AS/400 journaling, iSeries Journalling, Journaling
Hi, I have a journal entry of type IZ and I was wondering what causes this to be generated? The documentation says it is from an INZPFM command but the program specified on the journal entry does not execute this command.
Answer Question
| October 30, 2010 1:24 PM
AS/400 commands, AS/400 journaling, iSeries Journalling, Journaling
Extracting in SQL Server 2005
IS THERE ANY WAY TO EXTRACT FROM A FIED EXAMPLE: I HAVE A ADDRESS LINE AS 1065 VALLEY LANE APT 120 SCHAUMBURG IL 60195 I NEED TO EXTRACT APT 120 INTO ANOTHER LINE LIKE APT 120 1065 VALLEY LANE SCHAUMBURG IL 60195
Answer Question
| October 27, 2010 1:17 PM
EXTRACT, Field-Level keywords, SQL 2005, SQL 2005 Database, SQL Server 2005
IS THERE ANY WAY TO EXTRACT FROM A FIED EXAMPLE: I HAVE A ADDRESS LINE AS 1065 VALLEY LANE APT 120 SCHAUMBURG IL 60195 I NEED TO EXTRACT APT 120 INTO ANOTHER LINE LIKE APT 120 1065 VALLEY LANE SCHAUMBURG IL 60195
Answer Question
| October 27, 2010 1:17 PM
EXTRACT, Field-Level keywords, SQL 2005, SQL 2005 Database, SQL Server 2005
Key Mapping Error when writing records in AS/400
When i try to write to record, i am getting Key Mapping error.Please let me know if somebody has faced this type of error
Answer Question
| October 31, 2010 1:03 PM
AS/400, AS/400 error messages, AS/400 errors, AS/400 Records
When i try to write to record, i am getting Key Mapping error.Please let me know if somebody has faced this type of error
Answer Question
| October 31, 2010 1:03 PM
AS/400, AS/400 error messages, AS/400 errors, AS/400 Records
RPG and Service Programs
I’m getting into the “MVC pattern” experience of RPG programming, thanks to Scott Klement’s hints (see “A pattern for reusable code” on his site http://www.scottklement.com and “Binder Language and the Signature Debate” at http://systeminetwork.com/print/64029). After some initial difficulties, I have made an application based on a collection of procedures in a service program (SP) and [...]
Answer Question
| October 29, 2010 10:44 AM
AS/400, MVC pattern, OS/400, Service program, V5R4
I’m getting into the “MVC pattern” experience of RPG programming, thanks to Scott Klement’s hints (see “A pattern for reusable code” on his site http://www.scottklement.com and “Binder Language and the Signature Debate” at http://systeminetwork.com/print/64029). After some initial difficulties, I have made an application based on a collection of procedures in a service program (SP) and [...]
Answer Question
| October 29, 2010 10:44 AM
AS/400, MVC pattern, OS/400, Service program, V5R4
OVRPRTF AND OVRDSPF
Hi, Please give me real senario where we can use ovrprtf and ovrdspf? In priterfile why we use ovrprtf ? thanks vg
Answer Question
| October 27, 2010 6:47 AM
OVRDSPF, OVRPRTF, Printer files, RPG/400
Hi, Please give me real senario where we can use ovrprtf and ovrdspf? In priterfile why we use ovrprtf ? thanks vg
Answer Question
| October 27, 2010 6:47 AM
OVRDSPF, OVRPRTF, Printer files, RPG/400
Retrieving Last 7 days Details in AS/400
I’ve a senario, In that i need to extract last 7 days details using query in AS/400. I tried with MAX function. In that it takes MAX(&CURNTDATE) as whole number and subtract. For example i’m subtracting 7 from today’s date (1101027 – 7), i got 1101020. If i subtract 40 means i got 1100987. Can [...]
Answer Question
| November 1, 2010 6:30 AM
AS/400 Function Logic, AS/400 Query, MAX
I’ve a senario, In that i need to extract last 7 days details using query in AS/400. I tried with MAX function. In that it takes MAX(&CURNTDATE) as whole number and subtract. For example i’m subtracting 7 from today’s date (1101027 – 7), i got 1101020. If i subtract 40 means i got 1100987. Can [...]
Answer Question
| November 1, 2010 6:30 AM
AS/400 Function Logic, AS/400 Query, MAX
Need a Sample of Logical Network Design
I need a sample of logical network design including the access layer, distribution layer and core layer for the following issues – A. The first option is to produce software that the clients can download on their computers to run. The tool will carry out the processing on the clients’ computers and would occasionally need [...]
Answer Question
| February 16, 2011 6:28 AM
Client Access, Logical Network Design, Networking, WLAN, WLAN access points
I need a sample of logical network design including the access layer, distribution layer and core layer for the following issues – A. The first option is to produce software that the clients can download on their computers to run. The tool will carry out the processing on the clients’ computers and would occasionally need [...]
Answer Question
| February 16, 2011 6:28 AM
Client Access, Logical Network Design, Networking, WLAN, WLAN access points
Excel 2007 what is the command for scrolling down your rows with still seeing the header row at the top
I know this is so simple but what is the command for scrolling down through rows in Excel 2007 but still keeping the header (titles of the columns) in view. thanks so much!
Answer Question
| October 29, 2010 3:32 AM
COMMANDS, Excel 2007, Excel 2007 functions
I know this is so simple but what is the command for scrolling down through rows in Excel 2007 but still keeping the header (titles of the columns) in view. thanks so much!
Answer Question
| October 29, 2010 3:32 AM
COMMANDS, Excel 2007, Excel 2007 functions
