QSH on two differnet iSeries
Hello Everyone, I’m working with two different iSeries boxes. Using a CL program, I execute a QSH similar to this: STRQSH CMD(&COMMAND) &COMMAND is a string built inside the CL Program. When I call the CL program on the first box (call it DEV) it runs fine. When I call the CL program on the [...]
Answer Question
| January 22, 2010 4:21 PM
AS/400, CLP, iSeries, QSH, STRQSH
Hello Everyone, I’m working with two different iSeries boxes. Using a CL program, I execute a QSH similar to this: STRQSH CMD(&COMMAND) &COMMAND is a string built inside the CL Program. When I call the CL program on the first box (call it DEV) it runs fine. When I call the CL program on the [...]
Answer Question
| January 22, 2010 4:21 PM
AS/400, CLP, iSeries, QSH, STRQSH
Where to find now IBM models and features tables?
IBM used to have a find web page where you could configure a search process based on processor feature, model, processor characteristic, cpw…and more. But they don’t maintain/update/host it anymore? Any idea where to find anything similar and quick, withouth having to call a consultant?
Answer Question
| January 23, 2010 4:19 PM
AS/400, iSeries, System i
IBM used to have a find web page where you could configure a search process based on processor feature, model, processor characteristic, cpw…and more. But they don’t maintain/update/host it anymore? Any idea where to find anything similar and quick, withouth having to call a consultant?
Answer Question
| January 23, 2010 4:19 PM
AS/400, iSeries, System i
AS/400 Command Line
The capabilities of my user profiles are limited via LMTCPB(*YES). But the ERP package which we use (ASW from IBS) needs the command GO to work properly. So I had to set this command free for usage via ALWLMTUSR(*YES). Now of course, my users can enter GO MAIN or GO DATA and do whatever the [...]
Answer Question
| January 22, 2010 5:10 PM
ALWLMTUSR, AS/400, Command line, GO, iSeries, LMTCPB
The capabilities of my user profiles are limited via LMTCPB(*YES). But the ERP package which we use (ASW from IBS) needs the command GO to work properly. So I had to set this command free for usage via ALWLMTUSR(*YES). Now of course, my users can enter GO MAIN or GO DATA and do whatever the [...]
Answer Question
| January 22, 2010 5:10 PM
ALWLMTUSR, AS/400, Command line, GO, iSeries, LMTCPB
Can I read a Word doc in the IFS in an RPG program?
I am looking for a way to read the contents of a Word doc in the IFS from an RPG program. Does anyone know of a way to do this? I have found some articles about using QShell or PASE to read text files, but I am not sure if they will work for Word [...]
Answer Question
| January 16, 2010 2:17 PM
iSeries, RPG
I am looking for a way to read the contents of a Word doc in the IFS from an RPG program. Does anyone know of a way to do this? I have found some articles about using QShell or PASE to read text files, but I am not sure if they will work for Word [...]
Answer Question
| January 16, 2010 2:17 PM
iSeries, RPG
iSeries Token Error
Need help with this query – it will not run token error. Here is the query: SELECT SUM (“T16.CTDT”.TD_DETAIL_AMT_01 * .10) AS TOTAL, “T16.CPRP”.CP_DISTRICT_CODE
Answer Question
| January 15, 2010 5:12 PM
iSeries, iSeries Navigator, Query, Token Error
Need help with this query – it will not run token error. Here is the query: SELECT SUM (“T16.CTDT”.TD_DETAIL_AMT_01 * .10) AS TOTAL, “T16.CPRP”.CP_DISTRICT_CODE
Answer Question
| January 15, 2010 5:12 PM
iSeries, iSeries Navigator, Query, Token Error
sql what is TOSTMF
In SQL what is TOSTMF for an output file, and how do I use it?
Answer Question
| January 5, 2010 6:34 PM
iSeries, SQL, TOSTMF
In SQL what is TOSTMF for an output file, and how do I use it?
Answer Question
| January 5, 2010 6:34 PM
iSeries, SQL, TOSTMF
Getting authorization to service a job.
I’m trying to debug a bath program. But, I don’t have authority to the job. Here’s the error mesage: Additional Message Information Message ID . . . . . . : CPF3676 Severity . . . . . . . : 30 Message type . . . . . : Diagnostic Date [...]
Answer Question
| March 3, 2010 4:16 PM
AS/400, authority issue, iSeries, Security
I’m trying to debug a bath program. But, I don’t have authority to the job. Here’s the error mesage: Additional Message Information Message ID . . . . . . : CPF3676 Severity . . . . . . . : 30 Message type . . . . . : Diagnostic Date [...]
Answer Question
| March 3, 2010 4:16 PM
AS/400, authority issue, iSeries, Security
website on iSeries not being indexed by web search engines
Our website is hosted on our iSeries. It appears that our pages are not being indexed by the various web search engines. Has anyone encountered this? Any ideas on where to look/what to check? We are using our ip address not a DNS name. All pages are encrypted (https).
Answer Question
| December 24, 2009 5:50 PM
iSeries, Search engines, Search Indexing, Web development
Our website is hosted on our iSeries. It appears that our pages are not being indexed by the various web search engines. Has anyone encountered this? Any ideas on where to look/what to check? We are using our ip address not a DNS name. All pages are encrypted (https).
Answer Question
| December 24, 2009 5:50 PM
iSeries, Search engines, Search Indexing, Web development
can i create a directory in a CL with a variable name?
I am running a job that many people can submit at one time, I am writing files to qtemp and am putting into a directory in the IFS, but I would like to create a directory with the jobnumber as the directory name, then remove it when the job is complete.
Answer Question
| December 4, 2009 4:14 PM
IFS Directory, IFS Directory to iSeries Folder, iSeries
I am running a job that many people can submit at one time, I am writing files to qtemp and am putting into a directory in the IFS, but I would like to create a directory with the jobnumber as the directory name, then remove it when the job is complete.
Answer Question
| December 4, 2009 4:14 PM
IFS Directory, IFS Directory to iSeries Folder, iSeries
Has anyone connected a Droid to AS400?
Was thinking of getting updated Blackberry but after playing with my son-in-law’s Droid – it is VERY cool. And open. I.E. TN5250, etc.
Answer Question
| December 5, 2009 1:38 PM
AS/400, Droid, iSeries, TN5250
Was thinking of getting updated Blackberry but after playing with my son-in-law’s Droid – it is VERY cool. And open. I.E. TN5250, etc.
Answer Question
| December 5, 2009 1:38 PM
AS/400, Droid, iSeries, TN5250
Delete and Update in Query Magager
How can I use delete and update statments in Query Manager (QMQ) in OS/400. I can able to create QM Queries for Select Statment but not able to update tables using Delete and Update statment. Please help, a production project in pending for this.
Answer Question
| November 24, 2009 2:00 PM
iSeries, OS/400, Query Manager
How can I use delete and update statments in Query Manager (QMQ) in OS/400. I can able to create QM Queries for Select Statment but not able to update tables using Delete and Update statment. Please help, a production project in pending for this.
Answer Question
| November 24, 2009 2:00 PM
iSeries, OS/400, Query Manager
FTP a Synon edtrcd1
I made changes to the EDTrcd screen and after compiling it I FTP the new object Via *SAVF to the other server the object moves succesfully and the creation date& time of the OBJ are also same but the changes i have done are not seen inspite the oldscreen is shown.here both server use diplay [...]
Answer Question
| November 2, 2011 9:14 AM
FTP, iSeries, Synon/2E
I made changes to the EDTrcd screen and after compiling it I FTP the new object Via *SAVF to the other server the object moves succesfully and the creation date& time of the OBJ are also same but the changes i have done are not seen inspite the oldscreen is shown.here both server use diplay [...]
Answer Question
| November 2, 2011 9:14 AM
FTP, iSeries, Synon/2E
SQLRPGLE Cursors and Recursion
I’m trying to recursively call a PI in my SQLRPGLE program. Problem is, I get an SQLCODE error of -519 and I’m sure it has to do with cursors and the prepare statement in my PI. Here’s the code: pprintPrograms b dprintPrograms PI d program 10a value d spacer 10a value [...]
Answer Question
| April 12, 2012 11:09 PM
iSeries, Recursion, SQL Cursors, SQLRPGLE
I’m trying to recursively call a PI in my SQLRPGLE program. Problem is, I get an SQLCODE error of -519 and I’m sure it has to do with cursors and the prepare statement in my PI. Here’s the code: pprintPrograms b dprintPrograms PI d program 10a value d spacer 10a value [...]
Answer Question
| April 12, 2012 11:09 PM
iSeries, Recursion, SQL Cursors, SQLRPGLE
data search using popup window
Is there a sample RPG/CL/SQL code on how to create a popup window to search data from a PF?
Answer Question
| November 17, 2009 12:44 AM
CL, iSeries, Physical Files, RPG, SQL
Is there a sample RPG/CL/SQL code on how to create a popup window to search data from a PF?
Answer Question
| November 17, 2009 12:44 AM
CL, iSeries, Physical Files, RPG, SQL
Notes agent accessing attachment from IFS on another iSeries
I have a domino server running on an iSeries(Ranger). Through a scheduled agent I am trying to put an attachment from a different iSeries (Raven) in a notes document. I am having difficulties with this. When the IFS was local (on the same iSeries) it was easy, just point to the directory with a file path [...]
Answer Question
| January 12, 2010 2:29 PM
AS/400, AttachMent, IFS, iSeries
I have a domino server running on an iSeries(Ranger). Through a scheduled agent I am trying to put an attachment from a different iSeries (Raven) in a notes document. I am having difficulties with this. When the IFS was local (on the same iSeries) it was easy, just point to the directory with a file path [...]
Answer Question
| January 12, 2010 2:29 PM
AS/400, AttachMent, IFS, iSeries
AS 400 software problem
Received the following in wrkprb should I contact IBM Problem message ID . . . . . . . : CPI93B9 Severity . . . . . . . . . . . . : None Problem type . . . . . . . . . . : Machine detected Problem category . . [...]
Answer Question
| November 6, 2009 5:27 PM
AS/400, AS/400 error messages, iSeries, WRKPRB
Received the following in wrkprb should I contact IBM Problem message ID . . . . . . . : CPI93B9 Severity . . . . . . . . . . . . : None Problem type . . . . . . . . . . : Machine detected Problem category . . [...]
Answer Question
| November 6, 2009 5:27 PM
AS/400, AS/400 error messages, iSeries, WRKPRB
iSeries SQL UDF gets CPF426A
I created a SQL UDF using the iNav wizard. It created the service program for me yet when I try to use the function I get CPF426A “User-defined function &5 cannot be invoked.” with a reason 2 (Either the service program is not found or the program entry point &6 does not exist.) It says [...]
Answer Question
| November 30, 2009 3:02 PM
iSeries, SQL, UDF Returning DATE
I created a SQL UDF using the iNav wizard. It created the service program for me yet when I try to use the function I get CPF426A “User-defined function &5 cannot be invoked.” with a reason 2 (Either the service program is not found or the program entry point &6 does not exist.) It says [...]
Answer Question
| November 30, 2009 3:02 PM
iSeries, SQL, UDF Returning DATE
IBM i certifications
Hi, can anybody plz list out the types of certifications one can do on IBM i including the administration and development. I am experienced over 5 yrs in development and a novice in administration. Hence to move my career ahead and as an administrator too i wanna do some certifications. Plz help me out. Or [...]
Answer Question
| January 12, 2010 2:00 PM
AS/400 careers, Certification and specializations, iSeries
Hi, can anybody plz list out the types of certifications one can do on IBM i including the administration and development. I am experienced over 5 yrs in development and a novice in administration. Hence to move my career ahead and as an administrator too i wanna do some certifications. Plz help me out. Or [...]
Answer Question
| January 12, 2010 2:00 PM
AS/400 careers, Certification and specializations, iSeries
DSPOBJD – Storage Information
We have a production system and a DR system, we use MIMIX to keep the systems in sync. If I do a DSPOBJD on a Ile in both systems I get a Different value in the Storage Information : Size field. The number of records and everything are the same. Any Ideas ?
Answer Question
| November 28, 2009 6:04 PM
DSPOBJD, iSeries, iSeries Storage
We have a production system and a DR system, we use MIMIX to keep the systems in sync. If I do a DSPOBJD on a Ile in both systems I get a Different value in the Storage Information : Size field. The number of records and everything are the same. Any Ideas ?
Answer Question
| November 28, 2009 6:04 PM
DSPOBJD, iSeries, iSeries Storage
Binder Language
What Binder language meant for? I think to export Procedures outside the service program… Is it correct? I got a doubt that, If ina module, a procedure is defined as EXPORT then any way we can access it from any other module. In that case what the need of Binder lang?
Answer Question
| April 10, 2012 2:32 PM
AS/400 Binding Directory, AS/400 programming, Databinding, iSeries
What Binder language meant for? I think to export Procedures outside the service program… Is it correct? I got a doubt that, If ina module, a procedure is defined as EXPORT then any way we can access it from any other module. In that case what the need of Binder lang?
Answer Question
| April 10, 2012 2:32 PM
AS/400 Binding Directory, AS/400 programming, Databinding, iSeries
