• 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.

    Modiyooch760 pointsBadges:
  • Jreport problem – floating point literal

    hi! I'm new here! I have a report and this is connect to db2/as400. When I compile i have the next error "[SQL0410] Floating point literal 2.00805121133377101E18 not valid. Cause...." I don't know what is happenning. The query I run in other program and this is right, so I think is something with...

    LouIT5 pointsBadges:
  • How to view unique entry of record in collumn?

    I have table containing same multiple records in collumn, when I goes into 'Define Query' and 'Select Records' of 'Query Definition Option', it shows me all record list, but I like to view only a single entry of each record. How could be querry in 'Select Records' of 'Query Definition Option' or do...

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

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

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

    Archunan30 pointsBadges:
  • AS400 – Query

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

    rajeshece1,215 pointsBadges:
  • 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

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

    PutzGrilla810 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:
  • Number of days between 2 dates

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

    Pherrick20 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.

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

Following