How many parameters can be used in as400 wrkqry?
how many parameters can be used in as400 wrkqry

Answer Question   |  August 31, 2010  1:13 PM
AS/400 Parameters, AS/400 Query, V5R4, WRKQRY

Client access Printing
I created a printer session to run as400 queries to a cannon IR 3225 printer.  The printer appears to be disconnected and had been working fine before.  What could have gone wrong

Answer Question   |  August 16, 2010  8:01 AM
AS/400, AS/400 Print Problems, AS/400 printing, AS/400 Query, Client Access Printing

AS400 user profile query
Can you query which users are enabled and have a specific initial menu?

Answer Question   |  July 20, 2010  7:08 PM
AS/400 Query, AS/400 user profiles

STRQMQRY: The variable should appear without quotes
In my cl the strqmqry I am passing 2 variables that are character but should be numeric when the query runs………….now they have the quotes around them……………..how do I get the quotes out of there so they are treated as numeric????

Answer Question   |  July 15, 2010  9:33 PM
AS/400 Query, Query Manager, STRQMQRY

like query not running in pg
hi i am running a query to select records which contains abc_ so i am running : var1= ‘abc_’ + ‘%’; so i am running in rpg as select name from table where name like :var1; query is running but not selecting any records ..please help me out

Answer Question   |  July 21, 2010  7:09 PM
AS/400 errors, AS/400 Query, AS400 RPGLE, RPGILE

Next step in my AS/400 career
Hi, I’ve been working for last 3.5 years in AS400 and in which Cobol400 as programming language. I didnot get any chance to work in RPG in these years. Actually i want to grow in my career as technical expert in AS400. But being only knowledge in cobol and cl, i am not sure that i [...]

Answer Question   |  July 2, 2010  5:42 PM
AS/400 careers, AS/400 Query, COBOL certifications, COBOL/400

with Delphi-adoquery AS400 to access
My question is, with Delphi-adoquery AS400 to access, but I have AS400 member at my table. How should we proceed, I need urgent help. Thank you for everything Library table field names: my library narpak2: tables mgpyvm: Members narpak2009

Answer Question   |  June 21, 2010  7:28 AM
AS/400, AS/400 Query, Delphi 7

OUTPUTQUE with CHGSPLFA
I have 2 users, one *USER and another *SECOFR When the user *USER change the spoolfile, the options was displayed                            Additional Parameters                                                                                              Output queue . . . . . . . . . .   QPRINT        Name, *SAME, *DEV       Library  . . . . . . . . . . .     QGPL        Name, [...]

Answer Question   |  June 4, 2010  9:34 PM
AS/400 Query, AS/400 Reports, Output Queues

When Prototype changes, can we use binder source?.
When Prototype changes, can we use binder source?. I mean when procedure prototype changes ( parameter list changes), can we use binder source?. I guess no, we have to recompile and update all programs uses that procedure. pleae confirm

Answer Question   |  May 29, 2010  10:15 AM
AS/400, AS/400 Query

AS/400 Query
I have to run a Query based on PF without DDS with record leghth 2997. I have to select Company Code ’01′ which is the 925-927 positions in the file. How do I do select in the Query? Please advice. Thank you.

Answer Question   |  May 14, 2010  4:44 PM
AS/400, AS/400 Query

SIL File, field ILQTY make it numeric
How can I make the field ILQTY in the SIL file (for invoices) make numeric, so that I can make a count in summaries? Thank you!

Answer Question   |  May 11, 2010  9:15 AM
AS/400 Query, Query

AS400 – Query
How to find the Count using RunQry and WrkQry Command without using Pagedown Key?  

Answer Question   |  July 30, 2010  11:03 PM
AS/400 Query

Forcing AS/400 query data to respect original data order
000012   FROM      DISACTDTA1/COGJREP T02,  000013             DISACTDTA1/COGKREP T01,  000014             DISACTDTA1/COCXREP T04,  000015             DISACTDTA1/COGDREP T03,  000016             SATACTDTA1/FINURED T05  000017   WHERE     GJEFZC = GKEFZC  000018     AND     GKB8ZC = CXB8ZC  000019     AND     T02.GJAN8X = T03.GDAN8X  000020     AND     T01.GKB8ZC = T05.NUB8ZC  000021     AND(    T02.GJCDZA = '001367'  000022     AND     ZONED(GJASZB/100), 5) BETWEEN 10901 AND 10912   This is the result of [...]

Answer Question   |  February 17, 2010  9:06 PM
*QRYDFN, AS/400 Query, QMQRY

Duplicate Records
Help – My query is returning duplicate records.  How do I eliminate that?  In addition, how can I total the adjustment amount and report one record?  Here’s the query: SELECT Distinct “T16.GNAM”.N_NAME, “T16.GNAM”.N_CITY, “T16.CADJ”.AD_TOTAL_ADJUSTMENT, “T16.CRDC”.RD_COMMENT    FROM QS36F.”T16.CADJ” AS “T16.CADJ”, QS36F.”T16.CRDC” AS “T16.CRDC”, QS36F.”T16.CPRP” AS “T16.CPRP”, QS36F.”T16.GNAM” AS “T16.GNAM”    WHERE “T16.CADJ”.AD_TAXBILL_NO = “T16.CRDC”.RD_TAXBILL_NO AND [...]

Answer Question   |  January 4, 2010  8:08 PM
AS/400 Query, Duplicate records

AS400 Query Join
I need expert help. I need to create a query that will use four tables. Each table has a column of data that I need for the report. The end result should display the following: Name, City, Amount, Reason.  Here is my first query that gives me the name and city: SELECT “T16.GNAM”.N_NAME, “T16.GNAM”.N_CITY FROM [...]

Answer Question   |  December 31, 2009  5:45 PM
AS/400 Query, JOIN, JOIN statement

AS/400 Query Join Duplicate Records
I have three files A, B, C in my join query. Test is between A – B, B – C. The type is 2 (match records to primary file). When I run the query, it is returning duplicates. What am I doing wrong?

Answer Question   |  December 31, 2009  1:27 PM
AS/400 Duplicate Files, AS/400 Query, AS/400 Records

AS/400 Query Join
I am joining four files. Each file has one field I need for my report. How do I determine which file is the primary one? Should the select records criteria all come from the primary file? As long as I test fields First>Second, Second>Third, Third>Fourth, shouldn’t it work just fine?

Answer Question   |  December 30, 2009  9:12 PM
AS/400 Query, JOIN statement

Query help-all columns are not coming over
When I look at query on define query it has all columns. When I actually run it to spool file its missing columns. Thanks Pam

Answer Question   |  December 22, 2009  2:50 AM
AS/400 queries, AS/400 Query

AS/400 Query – Timestamp of entry to char field
Hi friends, I am creating an account file with the command below: DSPJRN JRN(QSYS/QACGJRN) FROMTIME('26/09/2009') TOTIME('25/10/2009') ENTTYP(SP) OUTPUT(*OUTFILE) OUTFILFMT(*TYPE4) OUTFILE(QTEMP/QAPTACG4) How can I convert the Timestamp field called JATSTP to a new char field with the first four positions ?                              Define Result Fields                                                                                                             Type definitions using field names or constants and operators, press [...]

Answer Question   |  December 14, 2009  11:29 PM
AS/400, AS/400 Query

Can a nested query be run in AS/400?
There are multiple lines (sequenced) of my records in a table with the same Key. Example of the table Student No.     Name         Grade      1001              Michelle       Fail 1001              Michelle       Fail 1025              Peter           Fail 1025              Peter           Pass 1025              Peter           Pass I want to query Students with no Pass meaning. Select Student No. Where Grade = Fail and Student [...]

Answer Question   |  November 30, 2009  11:19 AM
AS/400 queries, AS/400 Query