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

    Modiyooch540 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:
  • Passing parms to Query400

    Has anyone ever come across a method of passing a parm into a query run - such as a date?

    Abbey120 pointsBadges:
  • How many parameters can be used in as400 wrkqry?

    how many parameters can be used in as400 wrkqry

    Urband5 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

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

    PutzGrilla710 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:
  • AS 400 Query File Reference

    How would you go about identifying file, field and output references of a group or *all AS400 queries? I need to be able to identify files where used in queries.

    Modiyooch540 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