How do I disable the query timeout property?
I’m calling a stored procedure on the AS/400 from Visual Basic .Net. When the stored procedure executes, I get the SQL0666 message (query exceeds specified time limit or storage limit). The query timeout property on the box is set to *NOMAX and I’ve Reorg’d the files too. The message appears to be coming from the [...]

Answer Question   |  October 23, 2009  3:33 PM
AS/400 Client Access, AS/400 performance, AS/400 Query

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?

Answer Question   |  December 23, 2008  9:42 PM
AS/400 Query, AS/400 Query Select Records

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

Answer Question   |  December 17, 2008  10:49 PM
AS/400 FTP, AS/400 objects, AS/400 Query

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

Answer Question   |  December 10, 2008  9:45 PM
AS/400 Query

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 [...]

Answer Question   |  December 9, 2008  3:42 AM
AS/400 objects, AS/400 Query, RUMBA AS/400 Edition, RUMBA Software

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 can I run a Query [...]

Answer Question   |  December 2, 2008  7:21 PM
AS/400, AS/400 Duplicate Files, AS/400 Query

AS400 Query Dates
How do you computed dates in Query

Answer Question   |  November 26, 2008  1:43 PM
AS/400 Query, Query/400

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 + *EQ “&SATDYYMD”‘) /*the variable contains the date*/ CPYFRMQRYF FROMOPNID(filename) TOFILE(library/outputfile) + MBROPT(*REPLACE) CRTFILE(*NO) RUNQRY QRY(library/queryname) + QRYFILE((Library/filename) (library/outputfile) CLOF OPNID(filename) DLTOVR FILE(filename) —————————————————————————————– error message:Cause . . . . . : Control language (CL) [...]

Answer Question   |  November 26, 2008  9:03 AM
AS/400 error messages, AS/400 Query, Open Query, OPNQRYF, Run Query, RUNQRY

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, etc. without any instructions. [...]

Answer Question   |  January 26, 2009  5:12 AM
AS/400 applications, AS/400 Query, AS/400 training

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 Series software [...]

Answer Question   |  November 24, 2008  3:31 AM
AS/400 Query, CICS, IBM SNA, IBM Systems Network Architecture, IBM TXSeries, IBM TXSeries for Multiplatforms, LU 0 protocol, Systems Network Architecture, Telnet, TN3270

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!!

Answer Question   |  November 21, 2008  3:01 PM
AS/400, AS/400 Query, AS/400 user profiles

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 [...]

Answer Question   |  November 7, 2008  4:36 PM
AS/400 Query, DSPOBJD, Physical File

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.

Answer Question   |  September 25, 2010  3:06 PM
AS/400 Input Files, AS/400 Library, AS/400 Query

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) [...]

Answer Question   |  October 24, 2008  2:07 PM
AS/400 Query, iSeries, OPNQRYF, QRYSLT

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…

Answer Question   |  October 24, 2008  7:56 PM
AS/400 Query, IF statement

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 my time supporting [...]

Answer Question   |  August 21, 2010  5:22 PM
AS/400, AS/400 Query

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 [...]

Answer Question   |  October 8, 2008  3:47 PM
AS/400 database, AS/400 Query, Nested selects

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

Answer Question   |  August 9, 2010  6:51 PM
AS/400, AS/400 Query, AS/400 user profiles

New AS400 Query user, some knowledge
How do I find the library and file name to pull info from?

Answer Question   |  September 16, 2008  5:12 PM
AS/400 Query

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.

Answer Question   |  September 15, 2008  12:45 PM
AS/400 Query