DSXchange

whether you are running manually or running as per schedule, in the background dsjob command should be called. S, you need to pass -warn 0 to dsjob command. Why you want to ignore the warning rather than fixing the warnings? Thanks for your answer, im running the sequence by a .bat, so you said i h...

Hi, Im having the following problem. I schedule a sequence job that runs 5 job server, the problem is that every job server gives a warning and the sequence job is set by default to stop after 50 warnings. How can i ignore this 50 warnings? I run manually the sequence server y click in the option &q...

DataStage Job 234 Phantom 10560 Access violation. Attempting to Cleanup after ABORT was raised in stage DW_DIM_SELL_IN_OBJETIVOS_MJG..Oracle_OCI_0 DataStage Phantom Aborting with @ABORT.CODE = 3 This is from the previous run From previous run DataStage Job 234 Phantom 10992 DataStage Phantom Finished.

Hi guys,
Does anyone solved this problem. I read about it but never a solution to this.

"Oracle_OCI_0
DataStage Phantom Aborting with @ABORT.CODE = 3"

Im passing a Oracle query to a sequential file (TXT). The query works fine, if i view the data it shows normally.

Any idea?

Thanks

weekend happened, from friday to today all ODBC broke.
any idea

Hi, Im having a problem with the Microsoft ODBC Drivers. For some reason i can't understand suddenly my conections to the ODBC give no response. im getting the following error : "An exception occurred while trying to receive the response from the handler: An exection was received from the handl...

The problem with that is that i get this error : The following tokens in the 'dssendmail_template.txt' file have not been set in the call to DSSendMail: %from%

Hi masters, Does anyone knows how to mail warnings from a server Job. For example my server job finish with warnings because the stored procedure that executes fails. When i go to the director it shows the warning that the stored procedure gives, i want to mail the event detail that the director sho...

Hi guys,
In getting the following error in a job.

DataStage Job 180 Phantom 16764
Access violation.
Attempting to Cleanup after ABORT was raised in stage DW_FACT_TT..Oracle_OCI_6
DataStage Phantom Aborting with @ABORT.CODE = 3

Any idea?

Hi guys, I got a question. is it posible that using an ODBC with excel to have number of columns variable. this means today my excel have 5 columns, tomorrow i add a new one. how can i make that the new column that i create, automatically appear into my odbc query and columns define. Thanks

My actual derivation is like this: DSLink10.Field004+DSLink10.Field005+DSLink10.Field006+DSLink10.Field007.... in the oracle column

This is my sequential file info Product Code | Product Desc | Sale 1 | Sale 2 | Sale 3 000001 Beverage 15 0 8 000002 Biscuits 10 18 0 000003 Gums 2 3 2 This is my database Product Code | Product Desc | Total Sales 000001 Beverage 8 000002 Biscuits 0 000003 Gums 2 The thing is that the transform is n...

chulett wrote:Are you certain that all of the fields contain valid numeric data? Are any of them... 'empty'?

All the field are varchar and without empty fields

Mike, im trying to sum 200 columns. Im using the transformer to sum all the columns from the sequential file output into one from the oracle input, for example : DSLink10.Field004+DSLink10.Field005+DSLink10.Field006

But the result of that sum is not correct when i check it in the database.
thanks

Eric, can you explain me more about column export and where to do that.

thanks