seect records for current day
I want to run a daily job and select records that have been added on current date, field is 6,0 P in YYMMDD format, how can this be accomplished without modifying daily?
I want to run a daily job and select records that have been added on current date, field is 6,0 P in YYMMDD format, how can this be accomplished without modifying daily?
35 pts.
Send Object
Dear , How i can send one object from One Server to another server please tell me step by step and which command is use Regards, SNK
Dear , How i can send one object from One Server to another server please tell me step by step and which command is use Regards, SNK
who is signed on to the as400
Having been in unix too long don't have the command to display the active users on the as400, like the who command in unix
Having been in unix too long don't have the command to display the active users on the as400, like the who command in unix
AS/400 object location in library
Hi, I am a very new user to AS/400. I am using a RUMBA client and part of my "ticket" is entered through a free notes section. I can query other items such as customer name, dates, numbers etc etc, but i do not know how to locate where the object is for the "free notes" section to query this for...
Hi, I am a very new user to AS/400. I am using a RUMBA client and part of my "ticket" is entered through a free notes section. I can query other items such as customer name, dates, numbers etc etc, but i do not know how to locate where the object is for the "free notes" section to query this for...
Duplicated Files
Hi friends, I have a System (AS/400) and on this server i have many and many files with the same name , example: I have the file FILEX on LIB1, FILEX on LIB2, FILEX on LIB3 , etc ..... I Run the command DSPOBJD OBJ(*ALL/*ALL) OBJTYPE(*ALL) OUTPUT(*OUTFILE) OUTFILE(LIBTEST/FILETEST). Now, How...
Hi friends, I have a System (AS/400) and on this server i have many and many files with the same name , example: I have the file FILEX on LIB1, FILEX on LIB2, FILEX on LIB3 , etc ..... I Run the command DSPOBJD OBJ(*ALL/*ALL) OBJTYPE(*ALL) OUTPUT(*OUTFILE) OUTFILE(LIBTEST/FILETEST). Now, How...
OPNQRY
Hi ALL, I am trying to pass to variable to the query select. ----------------------------------------------------------------------------------------------- OVRDBF FILE(filename) SHARE(*YES) OPNQRYF FILE((library/filename) QRYSLT('DATE + ...
Hi ALL, I am trying to pass to variable to the query select. ----------------------------------------------------------------------------------------------- OVRDBF FILE(filename) SHARE(*YES) OPNQRYF FILE((library/filename) QRYSLT('DATE + ...
Trying to use AS/400 as a new employee
I've been hired by a retailer that uses AS 400 for just about everything, but provides almost no instructions or procedures to use the computers. As an older salesman (abt. 60), I have little experience with old DOS programs, but am now required to enter and edit sales orders, financing contracts,...
I've been hired by a retailer that uses AS 400 for just about everything, but provides almost no instructions or procedures to use the computers. As an older salesman (abt. 60), I have little experience with old DOS programs, but am now required to enter and edit sales orders, financing contracts,...
AS/400 Query
The customer is using custom gateway using IBM TX series (multiplatform v6) on AIX platform and the client's all IVR related transactions are available through LU 0 protocol only and we should not use any other in order to intract with AS 400 host (CICS). Please clarify the below: 1. The IBM TX...
The customer is using custom gateway using IBM TX series (multiplatform v6) on AIX platform and the client's all IVR related transactions are available through LU 0 protocol only and we should not use any other in order to intract with AS 400 host (CICS). Please clarify the below: 1. The IBM TX...
User Profile Info.
Hi, I want to write a query that will only pull the following info.: UserID, OutQ, Printer Device. What Library would house this information? Thanks in advance!!
Hi, I want to write a query that will only pull the following info.: UserID, OutQ, Printer Device. What Library would house this information? Thanks in advance!!
Finding newly created objects
I am trying to define a query to find any newly created objects ona daily basis. I have scheduled a job to run daily that creates a file to display all DSPOBJD which outputs into a physical file. I now want to query this file to find anything created on the previous day (the job runs overnight)....
I am trying to define a query to find any newly created objects ona daily basis. I have scheduled a job to run daily that creates a file to display all DSPOBJD which outputs into a physical file. I now want to query this file to find anything created on the previous day (the job runs overnight)....
Global change of file libraries in Query
Is there a way to globally change the libraries of the input files for a set of AS400 Queries, or possible force it to use *libl. I know that I entered *libl for the file selection, but it then defaults to a specific library.
Is there a way to globally change the libraries of the input files for a set of AS400 Queries, or possible force it to use *libl. I know that I entered *libl for the file selection, but it then defaults to a specific library.
Getting wildcard results from OPNQRYF
Hi all, I am trying to query a PF to get back all records where fields OWNER1 and OWNER2 have an entered user value (ie; JOHN - I would want to return JOHN, JOHNATHON, JOHNS, ARJOHNS, etc) The best so far I have been able to come up with is: DCL VAR(&CF03) TYPE(*CHAR) DCL VAR(&INOWN)...
Hi all, I am trying to query a PF to get back all records where fields OWNER1 and OWNER2 have an entered user value (ie; JOHN - I would want to return JOHN, JOHNATHON, JOHNS, ARJOHNS, etc) The best so far I have been able to come up with is: DCL VAR(&CF03) TYPE(*CHAR) DCL VAR(&INOWN)...
IF statement in AS/400 query
Can I use an if-type statement to return a different value? For example, i thought i would use define results fields to say if(lnt03=34,"advance","payoff") liek I would in excel. of course this doesn't work...
Can I use an if-type statement to return a different value? For example, i thought i would use define results fields to say if(lnt03=34,"advance","payoff") liek I would in excel. of course this doesn't work...
Query/400 replacement needed
I need to get serious about finding a replacement for Query/400 on our 9407/515. At first glance, there seems to be a variety of packages available from IBM and third parties, most of them much more capable and more complicated than Query/400. Unfortunately, I am not expected to spend any more of...
I need to get serious about finding a replacement for Query/400 on our 9407/515. At first glance, there seems to be a variety of packages available from IBM and third parties, most of them much more capable and more complicated than Query/400. Unfortunately, I am not expected to spend any more of...
Nested Selects
A project I am working on requires that I do some stuff on a iSeries/AS400 DB (which I'm accessing through a linked server on a remote machine). I'm trying to build a query, but some of the AS400 syntax is giving me problems, and I was hoping that someone would be able to help me with this. the...
A project I am working on requires that I do some stuff on a iSeries/AS400 DB (which I'm accessing through a linked server on a remote machine). I'm trying to build a query, but some of the AS400 syntax is giving me problems, and I was hoping that someone would be able to help me with this. the...
Find user profile list who has his audit code is blank or NONE
All, How can we find a user profile (part of audit group) who has his audit code is blank or NONE. Thanks Archie
All, How can we find a user profile (part of audit group) who has his audit code is blank or NONE. Thanks Archie
AS400 Query
How can you add a detailed note in AS/400 Query? I want to add the note to a file not a report.
How can you add a detailed note in AS/400 Query? I want to add the note to a file not a report.
what is syntax to convert minutes to days in an as/400 query?
I have a field in an as/400 query that shows minutes and I don't know how to define a result to convert it to days.
I have a field in an as/400 query that shows minutes and I don't know how to define a result to convert it to days.
