Home » RDBMS Server » Server Utilities » How do you determine value of column B based on column A's value.
How do you determine value of column B based on column A's value. [message #73435] Wed, 28 April 2004 09:43 Go to next message
spatemp
Messages: 8
Registered: April 2004
Junior Member
I want to determine a value of column B based on columns A value.  How do I do that.

Example:

LOAD DATA

INFILE 'C:TEMPDATA.TXT'

INTO TABLE TEMP

FIELDS TERMINATED BY "," OPTIONALYY ENCLOSED BY '"'

( A,

  B "DECODE(:A, 3, 'foundit', 'no')

)

 

DATA file contains only one column of data:

1

2

3

4

5

Report message to a moderator

Re: How do you determine value of column B based on column A's value. [message #73447 is a reply to message #73435] Sat, 01 May 2004 21:17 Go to previous message
Barbara Boehmer
Messages: 9097
Registered: November 2002
Location: California, USA
Senior Member
LOAD DATA
INFILE 'C:TEMPDATA.TXT'
INTO TABLE TEMP
fields terminated by whitespace
trailing nullcols
( A,
B "DECODE(:A, 3, 'foundit', 'no')"
)

Report message to a moderator

Previous Topic: field omission
Next Topic: is sqlload able to create the destination table ?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 16:31:08 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.