DSXchange

Putting @FALSE worked partially.

That stage is truncate existing data and then load, so it trucated the rows and then did not load the new data.

I really wanted ds to just ignore that entire link.

I have a transformer with 2 output links that each load into a tables.
I want to disable one of those links so I can test the other.

Thanks
Randy

Thanks,

the GMT data looks like this: 0493558525

I am not sure how to sure the examples, but will spend the night working on it.

I did a search for gmt and found very little.

A new data file is containg date/time formated as gmt.
I need to load this into an Oracle table, but am not sure how to handle it.

Can someone help me?

Thanks
Randy

How does the Wait_for_file stage work?
If the file is large and takes a couple of minutes to ftp, does the wff stage just look for the name or will it somehow know when the whole file is there?

Thanks
Randy

got it.
user defined sql

INSERT INTO tbl
(D_TRANSACTION_DATE_TIME)
VALUES
(TO_TIMESTAMP(:1, 'YYYY-MM-DD HH24:MI:SS.FF'))

not real elegant, but it works.

Thanks all

The same:

xfmLoad: ORA-01830: date format picture ends before converting entire input string

The length is 26
The scale is 6

I guess I could, but was really hoping to do it in datastage.
Isn't there someway of doing this?

Thanks, but the miliseconds if very important to the project.

Hi, I am getting the following error when I try to load a timestamp with miliseconds: ORA-01830: date format picture ends before converting entire input string I manipulate the date to look like this: yyyymmdd hh24:mi:ss.MMM I am using OCI9 and have the field defined as timestamp. Thanks for any sug...

You got me on this 32bit limit thing. How would I know?

the job is real simple. It's an ODBC to hash file. The hash file is then used in many jobs downstream.

there are no errors in the log. It just hangs.

It has happend 4 times in 3 months and run successfully about 1000.

Can someone suggest a method for limiting how long a job can run and aborting it if it exceds the time limit? I have a job that usually runs in less than a minute, but occasionally hangs and will run forever. Since no errors are being generated, troubleshooting it is hard. So until I stumble on why ...