• AS/400 tab text delimited format of physical file

    Hi , Using i series utility you can download PF as Text Tab Delimited format in your PC.However when I do the same by CLP using CPYTOIMPF using FLDDLM as X'05' or *tab , I get a text tab delimited file which is not completely same as the file downloaded using I series utility.

    Atti123135 pointsBadges:
  • Want to delete objects of type ‘File’ except ‘source physical file’

    I have taken output of DSPOBJD in a database file. Now I want to delete all the objects having type '*FILE' and object attribute 'PF' but the problem is I don't want to delete 'Source physical files'. I just want to delete files except 'Source physical file'. can anybody suggest how to do that ?

    pankaj2r100 pointsBadges:
  • 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:
  • Declaring the same file twice with two OPENID and reading the same file twice in CL Program

     Is it posssible read a db file while declaring twice with openID     and reading the same file twice

    Chraghuveer25 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?

    22917560 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:
  • EBCDIC Database File Problem

    My company received a file supposedly in EBCDIC format. We copied it to the shared network drive and attempted to FTP it several different times using several different types. The file transferred but when displaying it the records were all variable length and appears to have CR or EOL special...

    SKF75 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:
  • PHP + AS 400 on Windows machine

    I want to know that, i m on window machine and there i want to run my php script to handle AS400 Data base can any one let me know that how can i use this combination please be clear that i am using window machine

    Khawajaabid5 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:
  • find physical files with large record counts that are unused

    How can I capture the number of records (not file size) for numerous physical files via a cl command in order that I may download the information and find the ones with the largest number of records? I need to free up disk space so I need to find the files that have records but have not been...

    Hayleypatrick5 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