DSXchange

Hi, Agree with your observations. The job didnot die due to lack of rollback segments. It was completed. But as mentioned some of old rows were retained. ?? is this option - Clear Table and Then Insert Row option suppose to Delete ALL the rows from the table or not before doing INSERT? ?? If YES, bu...

Hi,

Yes your observations are correct.

? is this option - Clear Table and Then Insert Row option

suppose to Delete all the rows from the table or not?

Ketfos

Hi, I am loading data from sequential file to Oracle Table. The Update Action for the target table is Clear Table then Insert Rows. The Create Table for target table is Do not Create Table. I ran this first time and job was successful. (input file has 5000 records) I ran this for the second time wit...

Hi
You can also check with the following fucntion.

Since this type of data has char values greater than 122 and less than 65,
you may use condition as

if char(Arg1) < 65 or char(Arg1) > 122 then "****" else Arg1

Ketfos

Hi,
You need to look in Director and view the job log for the sequencer.

Ketfos

Hi,
Thanks
Do you have the same issue while you try to compile a routine.

Ketfos

Hi,

1. Were you able to compile your jobs without getting the compile window dialog box?

Ketfos

Hi Ken,
Does that mean that you cannot have more than one user defined sql in datastage (Query Type)

Ketfos

Hi,
How much time does normally the job takes to complete?

2. Have you tried ping command with a)hostname b)ip address.
This will make it sure that DNS is not screwing up. Sometime it works with ip address but fails with host name.

Ketfos

Hi,
Oracle OCI8 stage allows to write the individual statements seperated with semicolons after each statement to be executed from after tab in the SQL.

Ketfos

Hi,
In this case both the sever and client should running under Windows. (on same machine). Of course they will be completing for the same resource.

If the server is running under UNIX, the client and server will be on different machines and client talk to server via TCP/IP.

Ketfos

Hi,
Use internal date function of datastage with Oconv() s follows

Oconv(Date() , "D/YMD[4,Z,Z]")

Ketfos

Hi,
In your job properties for Sequential File Stage, is the column

First line is column names

checked?

Ketfos

Hi,
It looks like your input string contains non-ascii chars .

ketfos

Hi,
Are there any date fields? If yes, are you transforming them correctly from source to target?

Are their any null fields in input? How are you taking care of it?
Ketfos