DSXchange

When you say does not work, what does it do. does it give you an error? you can also write a script and call through before/after subroutine.

not sure but looks like the ID you are using does not have the necessary priviledges. In that case, you should not waste your energy finding different ways to do the task. Rather you should try and get the necessary priviledges first.+

try passing a Drop table command using teradata enterprise state (user defined SQL). you will have to have a dummy file (with dummy column and one dummy row) as source.

I have never tried this, but i dont see why this wont work.

As Craig said, you can use a sequence to generate your timestamps and pass it into the job as job parameters.

In case you really want the exact job run time (in microseconds) you can again use the sequencer to rename the file after the job has completed (after capturing the actual job run time)

Dont you have any date column in SQL server tables that identifies which rows are incremental? for the rows that get deleted,, you can perform a periodical refresh of oracle table. I would really be interested in knowing how those 200 tables can be refreshed in bulk (ie without using the above steps...

From the initial looks of it, your hash file looks corrupted. To ensure, open the hash file folder through Unix. If its corrupted you will see a large number of files in there instead of three expected ones (you may not be able to open the hash file folder ) Rename the hash file and run the job again.

Can anyone please explain why is this needed?

I got the same issue and this post helped me but i am still wondering why i had to convert it to float.

ArndW, I faced the same issue yesterday and was browind DSX for the resolution. I found a lot of thread discussing this issue. ex: http://www.dsxchange.com/viewtopic.php?t=116566&start=0&postdays=0&postorder=asc&highlight=APT_MONITOR_SIZE I changed the parameters and got rid of the f...

Change the following parameters:

$APT_MONITOR_TIME = 5
$APT_MONITOR_SIZE = 100000

this may resolve your warning "Oracle_Enterprise_85,0: sendWriteSignal() failed on node SVKCDISD01 ds = 0 conspart = 1 Broken pipe "

Let me know if this works.

chulett wrote:"Bouncing" = "rebooting" = stopping and then restarting DataStage. ...

I thought you were better at receiving jokes Craig.

check all the not null columns in oracle and see if you having nulls in those fields.

you have posted the same query twice in parallel forum and once in server forum on the same day.

Creating a number of threads doesnt guarantee answers. it only contributes to spamming.

In my job, 2 of my columns in the file are Char by nature and when getting loded into the table, they become Numeric by nature. The job runs fine but tends to generate a warning: you just cant load a char into an integer, you need to handle the spaces if any or check for any alphabetic or non-numer...

[quote="moose2079"]
Subject :We want to make Bouncing DS part of Weekly Releases
[quote]

And, what is a bouncing DS?? any new releases from IBM after ver 8?

Ray,

I am not able to open anything....is it just me and my office's stupid firewall? the link draws a blank.