• 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:
  • 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:
  • 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:
  • 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:
  • 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:
  • Converting date values in AS/400 database

    How do I convert a date value 20/09/1231 for 31st Dec 2009 in the database to be able to use a query of checking this date against current(date)?

    Bonbon7830 pointsBadges:
  • External DB2 Database link/trigger

    In Oracle I can register a database link to other data sources. For example, through ODBC I have registered DB2 as a database link. In this way I can read/insert/update from/into DB2 tables.

    r.otto810 pointsBadges:
  • UDS and DS

    I know well Data Strucutre (DS) and its usage, how an UDS (Data Area Data Structure) is different from and ordinary DS, I just find to know by myself but I was unable to find it. Can any one help me in expalainigt this?

    Kar425 pointsBadges:
  • Member Level ID

    Every evening we create Save Files of our Production Libraries on our Production System. The next morning we FTP these Save Files to our Development System and do Restores to our Production Libraries on our Development System. We use TurnOver to handle the changes to our SQL Tables, Indexes, and...

    wpoulin2,480 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