1
  • In a single CL Program, can we read a database file more than once?

    In a single CL Program, can we read a database file more than once

    Chraghuveer25 pointsBadges:
  • Encrypting AS400 database file

    I need to encrypt a database file residing on the as400 and FTP to a destination. Can I use QC3ENCDT to do this?

    Jeffm125 pointsBadges:
  • AS400 comparing large database files, cobol code taking too long

    Hi, I need to compare 2 large database files on the AS400, they have 20 million + records each. They are both keyed uniquely, exact same file layout. I need to identify inserted, updated and deleted records. I tried using cobol program reading first file with the unique logical, and matching with...

    ARTZONE25 pointsBadges:
  • DBF in AS/400 – last record written

    Hi , There is  file which has 6 fields and the first four as its key. Is there any way to figure out which is the last record written into it.   Thanks

    Atti123135 pointsBadges:
  • 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:
  • Reading a file in Reverse Order in CL Program

    ) In CL program how can we read a data base file in reverse order.

    Chraghuveer25 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:
  • 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:
  • 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:
  • AS/400 Spool Data Base File

    Is it safe to delete the Spool Data Base File? Object:Q04079N011 Type:*FILE Attribute: PF Library: QSPL

    c007285 pointsBadges:
  • Converting to .txt

    Hello All, I'm trying to convert an AS400 database file to a .txt with pipe delimeter and I want to make the .txt file name a batch number. 0012345.txt Any help is greatly appreciated.

    Breinhart45 pointsBadges:
1

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