• Defaults the Physical file with ‘%’ for Character fields and -9999 for Numeric fields.

    Hi all, I have requirements in which I have to pass the file as parameter to another program with defaulting the field value as, If character field default the first character as '%' and if Numeric default till the length of the field with -9999. As per now I'm getting two options. 1. Create the...

    ddaswani170 pointsBadges:
  • SQL update command to update certain digits in a row of a column with VARCHAR2(9) DATATYPE.

    Please I need an SQL command that I can use to update only the fourth and fifth digits in a particular column in an Oracle 9i database.The column has a VARCHAR2(9) datatype. My Oracle database is on Windows 2003 environment. Eg: The row in question reads '063150987' and I want to replace the fourth...

    IdongesitDaniel5 pointsBadges:
  • Difference between ODBC and JDBC?

    I'm writing a Java application. In short, this application needs to connect to DB2 on an AS/400 for some SQL data. I cannot find a straightforward comparison of ODBC and JDBC. Do any of you know where I can find one? Or, have any of you done java programming with the intent to connect to AS/400 SQL...

    Schmidtw11,330 pointsBadges:
  • Count distinct rows on multiple columns

    I want to write a single query that counts each distinct Student ID from the following sample data. Sample Data: ID NAME PLAN DESCR --- ------- ---- ------------------- 101 Michael 010C Cafe- 10.00 Dollars 102 Adam 010C Cafe- 10.00 Dollars 102 Adam 05CC Cafe- 5.00 Dollars 103 Jane 010C Cafe- 10.00...

    Mjackson0 pointsBadges:
  • DB2 Date function to convert number to Date

    In Cognos-Framework Manager there is a calculation in the DB2 section called "Date". Supposedly this field will change a numeric date "01012005" to an actual date "01/01/2005". But, we tried it and it does not work. Can you see if you can find anything that will allow us to create a calculated...

    Meenac0 pointsBadges:
  • DB2 Unload and Load JCL using IBM utility

    Hi, Can anyone provide me a JCL to unload and load DB2 tables using IBM utility. I'm new to DB2 and need to unload the Syspunch dataset for a table, as I need to load a the table with data. I just only have the file with the data to be loaded. So I need to get the syspunch file created first and...

    Ari200940 pointsBadges:
  • Oracle SQL and compare date

    Hello! I need help. I want to compare two dates and count how many days its between them. Example: 2006-09-22 and 2006-10-06 results: 14 days Hope for help. Thanks!

    MissNew0 pointsBadges:
  • SQL creating an unwanted duplicate of file

    The other day a colleague ran an SQL statement to update a field in a file to a constant where 2 other fields were equal to constants (so no joining was needed, etc.) When finished, there was a duplicate copy of the file in the first library in the library list. (Which is higher than the library of...

    BigKat7,935 pointsBadges:
  • How to select 1 record in DB2

    As usual, I often use: select top 1 * from table but in DB2, I can't. I use the Toad tool to input SQL statement. Does anyone have a solution? Please share it with me. Tkanks a lot!

    Linhntk5 pointsBadges:
  • Getting DB2 data into SQL 2008 database

    We have a web service for placing orders and sending them to our iSeries. Basically front ending the EDI package on the iSeries. If the data is sent over without errors on the SQL insert to the DB2 databases the job runs. If there are run time errors during order processing the errors are logged to...

    ToddN20008,500 pointsBadges:
  • SQL insert error in php

    When my php executes the db2 insert, I get error 7008. Any ideas what I might try to get it working ? The PF is new with *all public authority and no trigger nor journal. I manually added 1 record via green-screen SQL with the same context as what is assembled in my php. Here's the actual code in...

    aceofdelts1,850 pointsBadges:
  • Need to identify the next sequence of number in a character field in DB2

    I have a scenario where I need to find the next sequence of numbers in a character field. I found the starting position by using the LOCATE command but need to find the next sequence in the same row if anything. For Example: Issue Number : 01 Card Number 1234 5678 9012 3456. I found the starting...

    Dsaran2007150 pointsBadges:
  • pb exe runtime eror – does not connect to db2 database from client machine

    I have created an application using PB9.0.2 with database as db2 server db 9.7 on Windows XP Professional. the application works fine on all machines having PB installed. I have created an exe and copied the necessary files and dlls. this exe works fine on my machine, but does not work at all on...

    1111111q5 pointsBadges:
  • Anyone familiar with 4D front end to DB2 database

    Has anyone had experience with using 4D (4th Dimension) as a front end of IBM DB2 on iSeries? I've tried FTPing a database, it was downloaded to a PC into Excel, Excel had no problem retaining formatting...however I can't get DB2 to maintain the formatting and I used DDS to to generate the physical...

    Gmil494365 pointsBadges:
  • CPYF

    Is there any way to create a new physical file(say PF2) with same structure/fields as in a logical file(say LF1, whose physical file is PF1). One way is to use CPYF to create PF2 from LF1 but I dont wan't any data to be copied from LF1 to PF2 (dont want to use clrpfm after copying data) Is there...

    anuppdas105 pointsBadges:
  • Mainframe Performance Testing

    I am doing a research and would like to get answers to the following questions, I appreciate and value your experience and time: 1) What are the different types of mainframe applications? 2) What are the general performance issues that are expected? 3) What tools are used in performance testing...

    Iluvlearning0 pointsBadges:
  • File lock on DB2 AS/400

    How do I make a file lock on a DB2 file before accessing it, to ensure that is is not updated while I'm acccessing it ?

    train0125 pointsBadges:
  • AS400 DB2 Server User Access Audit

    Is there any way to track "User Account" information on a DB2 server specifically when a users account is locked?

    bsatl10 pointsBadges:
  • 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:

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