Data selection criteria to pull last months information
I run a series of queries at the beginning of each month to pull transactions from the previous month. Currently I am setting the date range for the julian dates. I would like to automate this series of queries and need a way to automate the data selection criteria so it will automatically pull...
I run a series of queries at the beginning of each month to pull transactions from the previous month. Currently I am setting the date range for the julian dates. I would like to automate this series of queries and need a way to automate the data selection criteria so it will automatically pull...
30 pts.
Authority to run a job to delete libraries and also sending spool files via email
Hi...could anyone please provide some guidance on the following:- I have been tasked with deleting libraries on our devlopment machine. I have used s DSPOBJD in my CL and specified QSYS in the library parameter to pick up all the libraries on the subsystem which are prefixed with certain letters...
Hi...could anyone please provide some guidance on the following:- I have been tasked with deleting libraries on our devlopment machine. I have used s DSPOBJD in my CL and specified QSYS in the library parameter to pick up all the libraries on the subsystem which are prefixed with certain letters...
CGI loses percent sign
We have a web app ( a CGI) written in RPGLE and HTML that prompts for several data fields and writes a record to our web iseries. When the Comments field contains a percent sign ("%"), the data file ends up without that symbol and the next character is gone, too. Is there a simple way to fix this ?...
We have a web app ( a CGI) written in RPGLE and HTML that prompts for several data fields and writes a record to our web iseries. When the Comments field contains a percent sign ("%"), the data file ends up without that symbol and the next character is gone, too. Is there a simple way to fix this ?...
Logging user views to a record on the AS/400
Is there a way on the As/400 to know every time a user accesses a specific record? I need to know when a user even looks at a record. I know I can use journaling to record changes to a record as well as adding and deleting records, but as far as I know, journaling will not record when a user...
Is there a way on the As/400 to know every time a user accesses a specific record? I need to know when a user even looks at a record. I know I can use journaling to record changes to a record as well as adding and deleting records, but as far as I know, journaling will not record when a user...
iSeries navagator and Windows 7
Hi Everyone we have some users that are now on windos 7 and when they try to use iseries navagator to drag splool files from the 400 to their desk top the file is unreadable and can not be saved. Has anyone else haveing this problem and is there a fix. Software/Hardware used: AS400 iseries
Hi Everyone we have some users that are now on windos 7 and when they try to use iseries navagator to drag splool files from the 400 to their desk top the file is unreadable and can not be saved. Has anyone else haveing this problem and is there a fix. Software/Hardware used: AS400 iseries
Retrieve the RPGLE program from object
Hi all, I accidently deleted my program. Is there any way to retrive the program from its object. Software/Hardware used: AS400
Hi all, I accidently deleted my program. Is there any way to retrive the program from its object. Software/Hardware used: AS400
The most-watched IT questions this week: Nov. 3, 2009
Here are the 10 most watched questions on ITKE: There’s some great discussions going on. Go answer a question now and take your shot at winning a TV: 1. Problem installing Exchange 2007 Management Tools was posed by Labnuke99 and answered by Mshen. 2. What Event ID was asked by Newbiepeon and...
Here are the 10 most watched questions on ITKE: There’s some great discussions going on. Go answer a question now and take your shot at winning a TV: 1. Problem installing Exchange 2007 Management Tools was posed by Labnuke99 and answered by Mshen. 2. What Event ID was asked by Newbiepeon and...
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...
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...
How to determine the processor type of iSeries? please read full question
To be more precise in the question, for example we have Intel Core2duo , AMD , Xenon and so many processors with appropriate GHZ given and speed as well. We have 825 box with a Processor feature code of 7418, does that fall under power4 /5 . Also we have a 720 box and a 820 box with processor...
To be more precise in the question, for example we have Intel Core2duo , AMD , Xenon and so many processors with appropriate GHZ given and speed as well. We have 825 box with a Processor feature code of 7418, does that fall under power4 /5 . Also we have a 720 box and a 820 box with processor...
Need to know whether a job is completed
Hi, I need to submit 2 jobs JOB 1 and JOB2 but before doing a sbmjob on JOB2 i should make sure that JOB 1 has ended. How can i do that during program execution. Thanks.
Hi, I need to submit 2 jobs JOB 1 and JOB2 but before doing a sbmjob on JOB2 i should make sure that JOB 1 has ended. How can i do that during program execution. Thanks.
AS/400 Program To List Physcial Files with Deleted Records
We currently have a program to list Physical Files with Deleted Records. The CLP utilizes the DSPFD command to build an out-file. The parameter for 'Type of Information' is *MBRLIST and 'File Attributes' is *PF. However, the out-file lists the data at the member level. Also, teh job takes TOO LONG...
We currently have a program to list Physical Files with Deleted Records. The CLP utilizes the DSPFD command to build an out-file. The parameter for 'Type of Information' is *MBRLIST and 'File Attributes' is *PF. However, the out-file lists the data at the member level. Also, teh job takes TOO LONG...
Auto reply for end of forms message PQT4103
Printers send to operator: [strong]Message ID . . . . . . : PQT4103 Severity . . . . . . . : 99 Message type . . . . . : Inquiry Date sent . . . . . . : 10/27/09 ...
Printers send to operator: [strong]Message ID . . . . . . : PQT4103 Severity . . . . . . . : 99 Message type . . . . . : Inquiry Date sent . . . . . . : 10/27/09 ...
I/O operation was applied to closed file error on AS400
I've got a program that outputs to two reports, a summary and a detail. Both printfiles are using the keyword usropn. I open the files at the begining of the program and I close them at the end. The files close after the totals are printed, the totals are only printed when LR is turned on. LR is...
I've got a program that outputs to two reports, a summary and a detail. Both printfiles are using the keyword usropn. I open the files at the begining of the program and I close them at the end. The files close after the totals are printed, the totals are only printed when LR is turned on. LR is...
Is it possible to restrict running of NASTIE (Now a simple tool in Excel) on system i
Is it possible to restrict running of NASTIE (Now a simple tool in Excel) on system i
Is it possible to restrict running of NASTIE (Now a simple tool in Excel) on system i
db2/400
Hi, on db2 hw to give the output query using webquery and consoal? And what is the meaning of webquery and consol?
Hi, on db2 hw to give the output query using webquery and consoal? And what is the meaning of webquery and consol?
SQLCODE = 1077952576
All- I'm getting the above error code from an RPGSQL program. This is just after a DECLARE statement. Other fields in the SQLCA are blank. I can run the statement in Interactive SQL w/o errors. I should be getting a small subset. I get 0 records. Any Ideas? It's not in the SQLCODE finder. Phil ...
All- I'm getting the above error code from an RPGSQL program. This is just after a DECLARE statement. Other fields in the SQLCA are blank. I can run the statement in Interactive SQL w/o errors. I should be getting a small subset. I get 0 records. Any Ideas? It's not in the SQLCODE finder. Phil ...
Message Queue
Lets say a user "accidently" sends the wrong message to a user. How can an administrator go into that message queue while its being used and delete it. This can be done when the user is signed off but now while in use. A sensitive message was sent and it needed to be deleted. I told them not to use...
Lets say a user "accidently" sends the wrong message to a user. How can an administrator go into that message queue while its being used and delete it. This can be done when the user is signed off but now while in use. A sensitive message was sent and it needed to be deleted. I told them not to use...
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 ? Software/Hardware used: IBM...
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 ? Software/Hardware used: IBM...
calling a URL from RPG OR CL
I would like to call a html. page from either a RPGLE or CL program. Software/Hardware used: AS400
I would like to call a html. page from either a RPGLE or CL program. Software/Hardware used: AS400
