View previous topic :: View next topic
|
Author |
Message |
rushing
New User
Joined: 25 May 2005 Posts: 13 Location: DaLian?China
|
|
|
|
Hi Everyone,
i have 1 question while loading table
the table has the folling fields:
NAME VARCHAR(17) NOT NULL,
GENDER CHAR(1) NOT NULL,
ADDRESS CHAR(20) NOT NULL,
SERIAL_NO CHAR(6) NOT NULL
my question is how to create a file myself which is used to load its records into the table to corporate the table layout, actually is to match the 'name' column, because its data type is varchar. |
|
Back to top |
|
|
rajandhla
Active User
Joined: 18 Oct 2005 Posts: 182 Location: Luton UK
|
|
|
|
Which utility are you using for loading the table........
Regards,
jai |
|
Back to top |
|
|
kondakonda
New User
Joined: 20 Mar 2006 Posts: 34
|
|
|
|
Hi,
For VARCHAR db2 elements corresponding cobol element is
10 NAME.
49 NAME-LEN PIC S9(4) USAGE COMP.
49 NAME-TEXT PIC X(17). |
|
Back to top |
|
|
rushing
New User
Joined: 25 May 2005 Posts: 13 Location: DaLian?China
|
|
|
|
hi rajandhla,
utility is load
hi kondakonda,
i'm using PL/I.
thanks for ur help.
I want to if i can create a file and then enter record manully
but it seems not working, so program may required, but how is the logic,
read record from one file and write to the load file? then how is the definition of the two files? |
|
Back to top |
|
|
|