Home » RDBMS Server » Server Utilities » SQL Loader combining fields
SQL Loader combining fields [message #70666] Thu, 11 July 2002 06:02 Go to next message
Lee
Messages: 56
Registered: May 1999
Member
Hello,

I'm trying to use sql loader to combine 2 character fields to create a third character field. The basic script I have is as follows:

LOAD DATA
...
FIELDS TERMINATED BY whitespace OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(^M
fielda char(2),
fieldb char(3),
fieldc char(fielda||fieldb)
)

Some test data would look like:
"01" "001"
"03" "123"

Thank you

Report message to a moderator

Re: SQL Loader combining fields [message #70671 is a reply to message #70666] Thu, 11 July 2002 10:07 Go to previous message
Lee
Messages: 56
Registered: May 1999
Member
Gottit

When I put the combined field to 0 it worked.

state_fips char(2),
cnty_fips filler char(3),
cofips char (0) ":state_fips||:cnty_fips",

Report message to a moderator

Previous Topic: Sql * Loader -350
Next Topic: AS-400 to Oracle Migration
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 23 15:06:30 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.