DSXchange

Guys, Can anyone help me with this issue. I need to use an oracle sequence (key.nextval) to assign to a ID field on the target table. I basically have a single oracle source, a transformer and a final target oracle table. Now what stage/derivation should i add to be able to assign that nextval of th...

Guys, I need to be able to set the commit frequency on the target Oracle Enterprise stage to be able to avoid problems with rollback segments. would like suggestions from anyone who has done that before. I know there was a Transaction Handling feature in server jobs that enabled us to specify 'rows ...

Guys, i need your help on another issue. For some reason, one of my server processes took forever to run and since its more than obvious that its hung, i decided to kill that process. Becoz all of us are using same userid's, i couldn't decide which one of the processes was mine, so asked everyone to...

There is a DSJobStartTimeStamp macro too available if you need to capture timestamp and still have no problem running it more than once a day.

craig

it worked. Thanks again.

i guess the manual should talk about setting the incomplete column to 'replace' as well, when i want to use the missing columns action, or i didnt read it properly, but anyways, thanks for the tip

Hi, i have a situation where i have 2 input files which have to be loaded into same target table. The difference between the two delimited files is that one has about 5 columns and the other has 8 columns. The first 5 columns of both are same. I want to use the same job to load data from both these ...

Are you sure that it was a SQL error corresponding to the '. What is the exact SQL error message. Because i used that with an ODBC stage (7.x) and it worked. Also a thing to check is that since you are doing a SELECT *, that you have as many columns defined as the number of columns that this query m...

Elaborating on what Craig said, Assuming you have only one input column in source sequential stage, just use a source sequential stage followed by an aggregator stage and then the target sequential stage. In the aggregator inputs tab, u need not sort or anything, but in outputs tab, select the deriv...

Just wanted to share this other alternative too.. was experimenting a little more even after i got it done following your suggestion. I realised we didnt have to write a routine for calling this shell script. In the routine activity, i can use the ExecSH and for the input argument, i gave the name o...

Hey Kenneth, Craig,

Got it done :D
Thanks so much for your help.

Thank you both for the suggestions. But i am stuck again with same issue i faced with EXECUTE COMMAND, the parameters that i passed through to the shell script had to be passed as arguments to the pl/sql code. But apparently even though it shows in the director log that it has substituted correct va...

thanks buddy, But again, when i was trying to implement this, had another doubt. Where do i specify the path of the shell script. I have used Call DSExecute('UNIX', 'tesh.sh' Arg1 Arg2 Arg3 Arg4 Arg5, output, output) When i run it, it is supposed to call a pl/sql inturn and update a table, but it do...

i cannot use the first option, coz my requirement is that this shell script in turn calls a pl/sql procedure to go set some value in a table. And immediately after that there are two jobs that go off simultaneously (and they both use that value in that table). So, i cannot write a before job subrout...

so, since all you need is a return value from that SELECT query, forget about procedure, use an ODBC stage, and select user-defined sql query option. Then in ViewSQL tab, write that SELECT query in either reference input or primary input depending on the kind of link you have used to connect it to t...

:?: I thought you can never return a value from a procedure into DataStage. You can return values from user-defined sql queries, but thats the limit. In ODBC Stage, the columns tab would refer to only the input parameters that the procedure can accept, but you cant specify columns to accept return v...