• query/400

    plz tell me how to work with query/400 on as/400 machine...thanks

    ten20081,150 pointsBadges:
  • Transfer Data from AS400 to Excel using Reflection

    I need help learning how to create a file transfer from the AS400 to an Excel spreadsheet using Reflection. I am not a "techie"; what I've learned has come from countless hours of using the "help" button and reading technical blogs. I knew how to create DTF requests when our company was using...

    Jillofalltrades50 pointsBadges:
  • Export AS/400 database to new website

    how would we go about exporting our as400 product database of 2,000 items (without images - only image name or link) to our new website?  we would likely be using a Joomla content management system (CMS) website but would use standard HTML if we had to.

    Sjames007725 pointsBadges:
  • DB2 Process automatically Shutdown

    At  our site using IBM DB2 database there some problem with our DB2 Database services stop automatically .Error log  shown the  DB2 PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN. Thanks, Nilesh

    Linuxroot35 pointsBadges:
  • sflcode & COBOL/400 code

    i have a database file name emp         file name=Emp R emprec    Eno           10p    Ename      10a    Esal          10p k Eno and subfile name is empsfl  sflrec Contain fields   SEno        10p   SEname   10a   SEsal       10p sflctl contain indicators...

    madhuchowdary350 pointsBadges:
  • AS400 DB2

    How do I access the data in a journal receiver?

    Esjef445 pointsBadges:
  • AS/400 field modification impact on other related objects

    I have a file field which we are planning to expand. The same field name is used in some of the files, DSPF's and PRTF's. If a program A has this impacted file declared, how can I find the other objects which are impacted due to this modification?

    22917510 pointsBadges:
  • How to run query in AS 400?

    New user, like to knw in detail how to run query in AS 400 with snapshot will be better.

    Shreekant40 pointsBadges:
  • Copy high volume of data between AS/400

    Neeed copy big file between iseries faster, this moment the requerided is 2 days? Need your coments to do the transfer more quicKly

    CRAMIREZ25 pointsBadges:
  • Database field in CLP

    hi, I am reading a database file line by line and want to display the records in QSYSOPR. i am using CHGVAR   VAR(&A)   VALUR(B)         where &A = variable in CL, and                  B = field from database file SNDPGMMSG &A MSGQ(QSYSOPR) But the problem is i am not...

    Sangay635 pointsBadges:
  • Using Number range on an AS/400 file with Char type field index

    Hi, I have scenario to filter records for screen presentation based on number range provided on screen.In database the numbers are stored as char with no padding.How can I use this character index to get the results without having to read entire file?

    Panpanky25 pointsBadges:
  • how many programmes are using any perticular database file in as400

    hi all, i m working on rpgile,if i have a logical file & i want to know list of programmes that r using that logical file ,what should i do? is there any command ??? thanks

    Ambrish 82310 pointsBadges:
  • Is a DB on AS400 always DB2 ?

    Please, I want to know if possible : when we speak about a data base on AS400, exactly a data base used by RPG, is it allways a DB2 database ? Is AS400 a database. Is it the same as DB2/400 ? I hope to be clear enough. Sincerely

    Poussines50 pointsBadges:
  • Responsibilities of DB2/400

    Hi, Being an AS/400 development/admin guy what are the roles and responsibilites of DB2/400(DB/400 ?) on daily basis.  What could be the  maintenance activities. I'm just curious about to know...waiting for your valuable comments..    

    qmaster1,675 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:
  • How would we know which index is been used during Native IO reads or SQL query execution happens on that file during program is being run?

    For example on an as/400 Data base file, some 10 indexes are created? How would we know which index is been used during Native IO reads or SQL query execution happens on that file during program is being run?

    TNKR130 pointsBadges:
  • Exceeding Limit in Excel

    I am loading 20k records from our AS/400 using Excel icon(transfer from AS/400) but after 16k records loaded I am getting message indicating that limit is over need to start in another worksheet. I changed file type under RECV - Details icon in AS/400 to Excel 5 then also no use same error. Pls Let...

    Alicsc370 pointsBadges:
  • Delete data files on the AS400

    I have a client that wants to remove all company data from an old AS400. Is there an easy way to do this, a single command or procedure?

    b.rogers5 pointsBadges:
  • Is it possible to get an alert when database page faults exceeds a certain amount.

    Is it possible to get an alert when database page faults exceeds a certain amount. Iam referring to the page faults which appear when we give the WRKSYSSTS command.  Or write a pgm which could monitor the page faults and sent an alert. 

    JohnsonMumbai1,160 pointsBadges:
  • CPYTOIMPF removed leading zeros from numeric field

    I am having a few problems using the CPYTOIMPF command. I am copying an external defined file on the AS400 to the IFS. It is removing leading zeros from numeric fields which I need the leading zeros in, such as company number. It also is placing trailing blanks in the numeric fields, which I don't...

    Rpgldb30 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