• AS400 user profile query

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

    Kiok45 pointsBadges:
  • 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????

    Harrigan5 pointsBadges:
  • 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 will make it....

    Thotts45 pointsBadges:
  • 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

    Zagerx20 pointsBadges:
  • AS/400 message queue

    Hi dear All, I'm stuck up.. in my first message queue program. I read message on the *msgq (using RCVMSG) and write it in a PF. I've 2 (dumb) Questions. 1. I provide 'message queue' as a parameter to RCVMSG command. when the command is executed, it reads only one row at a time. so If I've...

    Nutan70 pointsBadges:
  • 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                      ...

    PutzGrilla795 pointsBadges:
  • 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

    Alicsc370 pointsBadges:
  • Qry Mgmt losing edit word specs

    My 400 query has edit words specified for proper printing of the dates in my report, but I am passing parameters to select the correct data using STRQMQRY. My output is ignoring the edit words specified in the query

    smKny5 pointsBadges:
  • 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!

    David4045 pointsBadges:
  • Simple question about AS/400 query

    Maybe for you that will be a stupid question, but I'm taking the first steps and I don't know what exactly I have to do in the "Specify how to join files" screen. If I put more joints in more rows it is how there was an "and" before every new row? I mean, all the rows are conditions that have to be...

    Fabio5 pointsBadges:
  • Using LIKE in AS/400 Cobol

    How to use 'LIKE' in Cobol similar to query/400(example Field_A LIKE '%777%')

    111719555 pointsBadges:
  • Rounding

    how do l round up or round down values in a query/AS400?

    Tonchin5 pointsBadges:
  • Number of days between 2 dates

    How do I find the number of days between 2 dates? Julian or MM/DD/YY?

    Pherrick20 pointsBadges:
  • Why we take Break Message please explain in detail

    Hi, we take Break message once the operator change please explain me detail what is the whole purpose of taking the Break message... Thanks And regards Umesh

    Umeshkumarnagar15 pointsBadges:
  • changing qpquprfil in query

    how do i change the qpquprfil in as/400 query. i have doone it before and i know it is doabe but ican't rember how. i mean thesystem one not the one at the user level??

    Zonar5 pointsBadges:
  • 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  ...

    AS400 - Ask the Expert485 pointsBadges:
  • 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...

    lorit365 pointsBadges:
  • 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?

    lorit365 pointsBadges:
  • 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,...

    lorit365 pointsBadges:
  • 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?

    lorit365 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following