• Character delimited csv with double byte data

    I have a physical file on the iSeries (V7R1) that I am trying to send to the IFS using CPYTOIMPF. When I open the file on the IFS using Excel I expected to be able to parse the data using "Text to Columns" but the delimiter characters are missing and the text is garbled. Several of the fields...

    loztech15 pointsBadges:
  • Importing a .dbf file into IBM DB2 table

    I have a .dbf database file I want to upload to our IBM i5 and into a DB2 table. Is there an easy way to do this or am I going to need to convert the .dbf file into a .csv file? I\'ve tried using the CPYFRMIMPF command, but have had no such luck. Any help would be greatly appreciated.

    msoucy25 pointsBadges:
  • Email Validation Software

    We do a lot of bulk email blasts to our Students, in which we get a high percentage of bounced emails. We are looking into purchasing an Email Validation package and was wondering if anyone can recommend a decent package that would either run on the i5 (AS/400) or that can interface (via ODBC,...

    I5NEPA0 pointsBadges:
  • V6R1 restore Opt 21 to replacement box

    I have a complete Opt 21 save tape from my current 520 running V6R1. I have the following license pgms installed...Performance tools, DB2 query & SQL Dev kit, WDS, Client access. We found another 520 box(hardware upgraded), it has been wiped clean , no OS. Can I use our opt 21 tape and restore it...

    Svocal200940 pointsBadges:
  • execute dbms_utility.analyze_schema

    I tried to run the floowing command : execute dbms_utility.analyze_schema('CALLSINFO','ESTIMATE',500,0,'for table for all indexes for all indexed columns'); and i am having this error: ERROR at line 1: ORA-00376: file 1629 cannot be read at this time ORA-01110: data file 1629:...

    GSMoracle0 pointsBadges:
  • AMD Sempron

    Hi all, I have one desktop running on AMD sempron 2200. In my home network. It?s clock speed is 1.5 GHz as per manufacture?s specification. but in system properties It showing only 800 MHz. OS is using XP SP2. But it working very smoothly. Anybody have any idea about why it likes this?

    Squibc40 pointsBadges:
  • Cobol access to DB2 data over multiple LPARs

    I have an iSereis with 2 LPARs - one running V6R1 with a Cobol compiler (not ILE) and the other LPAR is running V5R3 with DB2 files.  What code and/or compiler options do I use to connect the v6r1 Cobol with the v5r3 database and how do I create the Cobol program to run on v5r3? Thanks

    Oldcobolguy5 pointsBadges:
  • Separate SUM results on a single line

    Can DB2 return separate SUMfunction within one statement. If I have : SELECT BRANCH,SUM(AMOUNT) ,COUNT(*) FROM TableA WHERE BRANCH IN (180002,180092) gives Branch,Amount,Count 180002,+100,3 can I return two SUMs - one for positive values of amount and one for negative amounts so will get :...

    PeterWarren15 pointsBadges:
  • VSAM versus DB2 in CPU consumption

    Is it possible estimate how much more CPU is consumed by DB2 commands in relation to VSAM KSDS when access a row, through an index scan, in a organized DB2 table against a record reading from an organized VSAM KSDS file through the primary index? How much is it in percentage? Thank you very much in...

    Abelmart30 pointsBadges:
  • I would like to run a report on AS/400 to indentify which DB2 tables to reorg.

    Hi,  New to iSeries. I need to identify which tables need to be reorged. From manual I see that if I do a DSPFD FILE(xxx/*ALL) TYPE(MBRLIST). I get a report where the Total deleted records are more than 10% of the total records I should reorg. Is there a report similar from DB2 side a utility...

    WendyB95 pointsBadges:
  • Expired or deleted RACF accounts that are still active in DB2

    Hello, I have a question related to 'expired or deleted RACF accounts that are still active in DB2'. In our shop, with z/OS as the operating system and RACF as a security tool. While DB2 native security is used to manage access for each of the DB2 objects such as database, table, view, or storage...

    Abeshaman5 pointsBadges:
  • as400

    what is the difference between source and object? Does source occupies the memory space?

    pdsathishkumar3,790 pointsBadges:
  • Database Diagram Tool

    Does anyone know of a free database diagram tool? I downloaded DBDesigner 4 (http://www.fabforce.net/dbdesigner4/), but it's not working the way I would like. I could just create them in Access but that isn't really ideal. I want to create diagrams of an existing database, not to create a new...

    sburkle0 pointsBadges:
  • Compressing Old Files

    Hello, I would like to know the option(Compressing Old Files) which comes up during disk cleanup in win XP and win 2000. Is it good or bad? I mean, If I do the compression regularly will that effect my system/files in a long run? Is it same to that option (compress drive to save space) in disk...

    BinooDas123410 pointsBadges:
  • DSNTEP2 output problem

    DSNTEP2 (aka SPUFI in batch) is causing problems for my extract JCL. How do you get rid of the SPUFI-like column headers from the output datafile produced by DSNTEP2? I don't have ANY experience with REXX, so an example would be appreciated. Jon

    Jonty Walker105 pointsBadges:
  • Access Oracle/Sybase/Informix from RPG

    Hi, I would like to access Oracle/Sybase/Informix directly from within an RPG program. This is something similar to ODBC but in reverse - my data source is external to the iSeries and my application and APIs, or called routines, internal in the iSeries. The access to the external database should:...

    JohnDavid5 pointsBadges:
  • reusedlt *yes

    Hi, Has reusedlt *yes behavior changed with V5R3? When I add a record to a PF that is reusedlt *yes in V5R2 is uses a record that has been deleted, however when i do the same thing on a V5R3 system it adds a new record rather than re-use one. Anyone run into this before? Thanks, Luis

    Xixones0 pointsBadges:
  • I have a table unload query, which is of length 33, But I need the output file length 80, which means 47 bytes extra..

    I have a table unload query, which is of length 33, But I need the output file length 80, which means 47 bytes extra..

    SujaGiscard5 pointsBadges:
  • Advice needed on “DB2 DBA for Z/OS career”

    Hello there, I am a mainframe professional with over 6 years of experience. I worked mainly in IDMS database throughout my career. However, i am interested to learn database administration in DB2. I did clear initial DB2certification long back. 1>  To do DB2 DBA, how difficult is it for me as...

    PM0075 pointsBadges:
  • Tried to go larger than storage limit for object OBJECTNM OBJECTNM

    OBJECTNM is our file name. Some of thedetails of the file are given below. Member size . . . . . . . . . . . . . . . . : SIZE       *NOMAX   Access path size  . . . . . . . . . . . . . : ACCPTHSIZ  *MAX1TB  Access path logical page size . . . . . . . : PAGESIZE   *KEYLEN  Total records  ....

    sim400305 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