Open List of Spooled Files (QGYOLSPL) API Filter Information Format OSPF0200
Our company has more than 85,000 spoolfiles to be filterd in different ways. I use List API QGYOLSPL with Filter Information Format OSPF0100 which was very qick. But to aply for a date range you have to use Format OSPF0200 where I got errors. Can anybody give a code example to flter usernames userid1 and [...]
Answer Question
| November 15, 2010 6:53 AM
DataCenter, RPGLE, Security
Our company has more than 85,000 spoolfiles to be filterd in different ways. I use List API QGYOLSPL with Filter Information Format OSPF0100 which was very qick. But to aply for a date range you have to use Format OSPF0200 where I got errors. Can anybody give a code example to flter usernames userid1 and [...]
Answer Question
| November 15, 2010 6:53 AM
DataCenter, RPGLE, Security
Robot – Change object security of fle REPPF in RBTREPLIB library
I am planning to read file REPPF from RBTREPLIB library from a program. The security of this object is setup as the following: User Object Authority *PUBLIC *EXCLUDE RBTUSER *ALL Because the way the security is setup, the program only will work for those users that complies with this security. Can I change the object [...]
Answer Question
| December 1, 2009 2:27 PM
Application development, AS/400, Development, Printing, RPG, RPGLE, Security, Software, Tech support
I am planning to read file REPPF from RBTREPLIB library from a program. The security of this object is setup as the following: User Object Authority *PUBLIC *EXCLUDE RBTUSER *ALL Because the way the security is setup, the program only will work for those users that complies with this security. Can I change the object [...]
Answer Question
| December 1, 2009 2:27 PM
Application development, AS/400, Development, Printing, RPG, RPGLE, Security, Software, Tech support
Transfer Data from iSeries to Excel
I am trying to use ‘Transfer data from iSeries’ add-on from within Excel. I have specified my library/file as : <><><><><><><> TANFILE/NCUFFLDR Data Option as: Select NCUFFLDR_COMPANY_TYPE Where (NCUFFLDR_COMPANY_TYPE=M) <><><><><><><> I receive CWBDB0036 SQL0206… M is not a column of table *N in *N. If the table is *N, M is not a column of [...]
Answer Question
| December 1, 2009 12:36 PM
AS/400, SQL
I am trying to use ‘Transfer data from iSeries’ add-on from within Excel. I have specified my library/file as : <><><><><><><> TANFILE/NCUFFLDR Data Option as: Select NCUFFLDR_COMPANY_TYPE Where (NCUFFLDR_COMPANY_TYPE=M) <><><><><><><> I receive CWBDB0036 SQL0206… M is not a column of table *N in *N. If the table is *N, M is not a column of [...]
Answer Question
| December 1, 2009 12:36 PM
AS/400, SQL
numeric field check
i have a file that has a numeric field that is being cleared early in a program if certain conditions are meet as the file is being made…i need to check later before that file is printed to see if those conditions have changed….the numeric field is the key….it’s not having zeros put in it..but [...]
Answer Question
| December 1, 2009 9:31 AM
AS/400, Data analysis, RPG, RPGLE
i have a file that has a numeric field that is being cleared early in a program if certain conditions are meet as the file is being made…i need to check later before that file is printed to see if those conditions have changed….the numeric field is the key….it’s not having zeros put in it..but [...]
Answer Question
| December 1, 2009 9:31 AM
AS/400, Data analysis, RPG, RPGLE
GDDM on V5R4
Can I display graphics on the screen Or print the graphics using GDDM on V5R4?
Answer Question
| December 1, 2009 2:24 AM
Application development, AS/400, Printing, RPG, RPGLE
Can I display graphics on the screen Or print the graphics using GDDM on V5R4?
Answer Question
| December 1, 2009 2:24 AM
Application development, AS/400, Printing, RPG, RPGLE
Monitoring program usage
Looking for a way to monitor certain command (strsql, upddta, etc) I need to know the user that ran the command and time/date, the file they were accessing would be nice
Answer Question
| December 1, 2009 2:38 PM
AS/400, Security
Looking for a way to monitor certain command (strsql, upddta, etc) I need to know the user that ran the command and time/date, the file they were accessing would be nice
Answer Question
| December 1, 2009 2:38 PM
AS/400, Security
Search for missing Semi-colon in Free format
Is there a way in either SEU, Code400 or the LPEX editor to do a search by exclusion? I’m looking for an easy way to identify lines of code, in Free format, that are missing the semi-colon at the end.
Answer Question
| December 4, 2009 10:45 AM
RPGLE
Is there a way in either SEU, Code400 or the LPEX editor to do a search by exclusion? I’m looking for an easy way to identify lines of code, in Free format, that are missing the semi-colon at the end.
Answer Question
| December 4, 2009 10:45 AM
RPGLE
Retrieving Job Info
I have a CL submitted from the Job Scheduler. In this job I need to kill an active job before processing, then strat it up again when processing is complete. For the active job I know the User ID and the Job Name and this is it, in addition there will always be more than [...]
Answer Question
| December 1, 2009 5:19 PM
Application development, AS/400, CLP, DB2 Universal Database, RPG, RPGLE, Web development
I have a CL submitted from the Job Scheduler. In this job I need to kill an active job before processing, then strat it up again when processing is complete. For the active job I know the User ID and the Job Name and this is it, in addition there will always be more than [...]
Answer Question
| December 1, 2009 5:19 PM
Application development, AS/400, CLP, DB2 Universal Database, RPG, RPGLE, Web development
Hexadecimal
Can someone please tell me the hex value of the [TAB] key Thanks
Answer Question
| December 1, 2009 7:17 AM
Application development, AS/400, Development, PC/Windows Connectivity, Printing, RPG, RPGLE
Can someone please tell me the hex value of the [TAB] key Thanks
Answer Question
| December 1, 2009 7:17 AM
Application development, AS/400, Development, PC/Windows Connectivity, Printing, RPG, RPGLE
Mapping a drive from QNTC
I have to have a drive from a Windows server permanently mapped to my ISerie for batch FTP purposes. When I issued the command MKDIR QNTC/servername, it worked fine. The problem is that at IPL time, the link is broken, What’s the best way to keep the connection with the Windows server? Should include the [...]
Answer Question
| November 30, 2009 4:35 PM
Application development, AS/400, DataCenter
I have to have a drive from a Windows server permanently mapped to my ISerie for batch FTP purposes. When I issued the command MKDIR QNTC/servername, it worked fine. The problem is that at IPL time, the link is broken, What’s the best way to keep the connection with the Windows server? Should include the [...]
Answer Question
| November 30, 2009 4:35 PM
Application development, AS/400, DataCenter
Replicating data between I-series and Ms-CRM using Scribe?
We are implementing MS-CRM on an Ms-SQL server. We need to replicate data from our business system (I-Series) to CRM, and similarly from MS-CRM to I-Series. Our Ms-CRM provider proposes using a product called Scribe to do this but has no experience of using this with I-series. Has anyone used scribe before with I-series? If [...]
Answer Question
| March 2, 2006 12:36 PM
AS/400, CLP, CRM, DataCenter, DB2 Universal Database, PC/Windows Connectivity, SQL, SQL Server
We are implementing MS-CRM on an Ms-SQL server. We need to replicate data from our business system (I-Series) to CRM, and similarly from MS-CRM to I-Series. Our Ms-CRM provider proposes using a product called Scribe to do this but has no experience of using this with I-series. Has anyone used scribe before with I-series? If [...]
Answer Question
| March 2, 2006 12:36 PM
AS/400, CLP, CRM, DataCenter, DB2 Universal Database, PC/Windows Connectivity, SQL, SQL Server
InfoPrint Server Mapping question
We are evaluating Info Print server and trying to use the mapping program to send emails. We are receiving error message PQT3611 Stream File not found for user. Has anyone experienced this issue?
Answer Question
| November 30, 2009 4:30 PM
AS/400
We are evaluating Info Print server and trying to use the mapping program to send emails. We are receiving error message PQT3611 Stream File not found for user. Has anyone experienced this issue?
Answer Question
| November 30, 2009 4:30 PM
AS/400
%diff and data structures
I have dates that come into my program as cn yy mm dd. I put these pieces in a ISO data structure to do some calcs. I want to find how many months transpired between to dates using the %diff. Can I do this with the dates being in a data structure? My program is [...]
Answer Question
| November 30, 2009 11:59 AM
RPG ILE
I have dates that come into my program as cn yy mm dd. I put these pieces in a ISO data structure to do some calcs. I want to find how many months transpired between to dates using the %diff. Can I do this with the dates being in a data structure? My program is [...]
Answer Question
| November 30, 2009 11:59 AM
RPG ILE
Viewing the list of libraries in *SYSVAL
Sudarshan wrote in with this question recently: “How can I see the list of libraries in *SYSVAL?” – Deb Tart, associate editor
Answer Question
| November 30, 2009 11:30 AM
AS/400
Sudarshan wrote in with this question recently: “How can I see the list of libraries in *SYSVAL?” – Deb Tart, associate editor
Answer Question
| November 30, 2009 11:30 AM
AS/400
XLS integration to Iseries
I am looking for information on getting XLS data to the Iseries. Specifically would like to get XLS into XML format so an EDI/XML translator can pick it up and send through our existing EDI processes. The XLS will come from e-mail clients.
Answer Question
| March 3, 2006 10:51 AM
Application development, CLP, E-business
I am looking for information on getting XLS data to the Iseries. Specifically would like to get XLS into XML format so an EDI/XML translator can pick it up and send through our existing EDI processes. The XLS will come from e-mail clients.
Answer Question
| March 3, 2006 10:51 AM
Application development, CLP, E-business
RPG programmer wants to move to Web dev
Mayank wrote in with this question recently: “I’m a core iSeries RPG programmer. I?d like to move to Web development. Where should I start?” – Debra Tart, associate editor
Answer Question
| February 27, 2006 10:31 AM
RPG, Web development
Mayank wrote in with this question recently: “I’m a core iSeries RPG programmer. I?d like to move to Web development. Where should I start?” – Debra Tart, associate editor
Answer Question
| February 27, 2006 10:31 AM
RPG, Web development
COMMAND – parameter title
What is the way to define parameters in a command so they will be indented and displayed under a title like: Inline Options:: . Inliner . . . . . . . . . . . *OFF *OFF, *ON . Mode . . . . . . . . . . . . . *NOAUTO [...]
Answer Question
| February 23, 2006 9:52 AM
Application development, AS/400, CLP
What is the way to define parameters in a command so they will be indented and displayed under a title like: Inline Options:: . Inliner . . . . . . . . . . . *OFF *OFF, *ON . Mode . . . . . . . . . . . . . *NOAUTO [...]
Answer Question
| February 23, 2006 9:52 AM
Application development, AS/400, CLP
Retrieve data from a PC to an iSeries
Katie wrote in with this question recently: Where can I get information to be able to retrieve data from a PC (or possibly be able to access data from IFS all day long) to the iSeries. I need to be able to have the iSeries open in communication all day long to a PC, PC [...]
Answer Question
| November 14, 2010 4:19 PM
RPG
Katie wrote in with this question recently: Where can I get information to be able to retrieve data from a PC (or possibly be able to access data from IFS all day long) to the iSeries. I need to be able to have the iSeries open in communication all day long to a PC, PC [...]
Answer Question
| November 14, 2010 4:19 PM
RPG
User Auditing/Journaling
I’m new to security on the AS/400 (730). We need to have a record of what program a user calls through our ERP system or what objects are changed and who changed them. I’ve read some on journaling but not sure if that will work for what we need. Suggestions? Thanks Mark
Answer Question
| November 30, 2009 9:39 AM
Application development, Application security, AS/400, AS/400 careers, Backup & recovery, Biometrics, CLP, Compliance, configuration, CRM, Database, DataCenter, DB2 Universal Database, Digital certificates, Disaster Recovery, Email, Encryption, Exchange, IBM Marketing Sound Off, Identity & Access Management, Instant Messaging, patching, PC/Windows Connectivity, PEN testing, Platform Security, Policies, Printing, provisioning, Risk management, RPG, RPGLE, Secure Coding, Security, Security Program Management, Security tokens, Single sign-on, vulnerability management, Web development
I’m new to security on the AS/400 (730). We need to have a record of what program a user calls through our ERP system or what objects are changed and who changed them. I’ve read some on journaling but not sure if that will work for what we need. Suggestions? Thanks Mark
Answer Question
| November 30, 2009 9:39 AM
Application development, Application security, AS/400, AS/400 careers, Backup & recovery, Biometrics, CLP, Compliance, configuration, CRM, Database, DataCenter, DB2 Universal Database, Digital certificates, Disaster Recovery, Email, Encryption, Exchange, IBM Marketing Sound Off, Identity & Access Management, Instant Messaging, patching, PC/Windows Connectivity, PEN testing, Platform Security, Policies, Printing, provisioning, Risk management, RPG, RPGLE, Secure Coding, Security, Security Program Management, Security tokens, Single sign-on, vulnerability management, Web development
cursors left open in embedded SQL
I have a problem with SQL cursors being left open, even after the “close cursor” instruction has been executed successfully (SQLSTT = ’00000′) from within an RPGIV program. There are 2 cursors within the program: 1 cursor is used for fetching the count of selected records, the other is a dynamic scroll cursor for fetching [...]
Answer Question
| November 14, 2010 5:32 PM
RPGLE
I have a problem with SQL cursors being left open, even after the “close cursor” instruction has been executed successfully (SQLSTT = ’00000′) from within an RPGIV program. There are 2 cursors within the program: 1 cursor is used for fetching the count of selected records, the other is a dynamic scroll cursor for fetching [...]
Answer Question
| November 14, 2010 5:32 PM
RPGLE
