View previous topic :: View next topic
|
Author |
Message |
Escapa
Senior Member
Joined: 16 Feb 2007 Posts: 1399 Location: IL, USA
|
|
|
|
Premkumar wrote: |
Per IBM manual it is possible with IF THEN.But
it is not saying how can it be done with the BUILD parameter. |
What you read there may not work in your shop..
Actually this is not the place you should look for. You need to see SYNCSORT manuals. |
|
Back to top |
|
|
PremKumarNair
New User
Joined: 12 Jan 2010 Posts: 27 Location: Pleasanton,CA
|
|
|
|
Sambhaji,
The topic in debate is resolved with Gerry's help.IFTHEN and OVERLAY did the trick.
Thank you and everyone for the valuable contributions.
I have requested moderators to mark the topic as "Resolved" in order to avoid further confusion. |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
PremKumarNair,
Do you have a manual?. If you dont have one, you can get it easily from the bmc website. The manual has a clear explanation of all the options with examples.
Here is a sample BMC Load card which uses a comma separated file as input. If the input is not comma(",") separated one, I guess you might need to add the "TERMINATED BY" parameter to the FORMATCSV option to specify the delimiter. And also you will have to make sure that the none of the data has the delimiter character(dot-"." in your case)
Code: |
LOAD DATA INDDN SYSREC01 REPLACE
ERRDDN SYSERR
DELETEFILES NO
DISCARDS 0
IFDISCARDS 5
LOG NO NOCOPYPEND
UPDATEDB2STATS YES BMCSTATS YES
WORKDDN SYSUT1
REDEFINE YES
FORMAT CSV ENCLOSEDBY '' (You might need a TERMINATED BY "." here)
INTO TABLE XXXXXXXX.TABLE_NAME
(
COL_1 POSITION(*)
,COL_2 POSITION(*)
,COL_3 POSITION(*)
...
...
..) |
|
|
Back to top |
|
|
PremKumarNair
New User
Joined: 12 Jan 2010 Posts: 27 Location: Pleasanton,CA
|
|
|
|
Thanks Arun.Appreciate your help. |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
You're welcome |
|
Back to top |
|
|
|