DSXchange

Hi all,

I want to insert the log entries like how many rows processed, status, time taken into database table while running the job. Which is the best way to get those information.

Thanks
Rasi

Hi All I am configuring ODBC to acces SQL Server Data from different server. It shows the DSN name but finally gives the following error message. " DSR.MetaGeta(GET.TABLES)(SQLConnect('dmssqlserver','ers2admin')): BCI Error: SQLSTATE=IM002,CODE=0,[DataStage][SQL Client][ODBC][DataDirect][ODBC l...

Hi,

If you know the table definitions then you can go and enter the column names and data types in the stage.

Thanks
rasi

Thanks Ray, But how will you move the blob from SQL Server to some folder destination. Also the content which is inside is XML. Thanks Rasi No. INSIDE DataStage (which was your question) you can only work with numeric and string data types. (What transformation would you apply to a BLOB? :) ) You ca...

Hi,

Is is possible to user Sql Server BLOB object inside DS.

Thanks
rasi

Hi, I am creating a job in which I want to insert one log record to my oracle table which has the jobname,number of rows processed and datetime stamp. If I use a output link to my oracle it will insert for every input record. But i need only one record for a job. Is there any way of doing in Datasta...

Hi Thanks for your answer. In continuation to your reply. How could i use outer join in the oci reference input link. many thanks rasi There are essentially three ways: OCI stage supplying a reference input link ODBC stage supplying a reference input link Hashed File supplying a reference input link...

Hi,

I want to know which is the best way to solve the following problem:

I want to get the max number from a sequence meta table and store in a variable. And then use the same value to a different stage variable.

thanks
rasi

hi,

I need to know which is the best way to use the lookup in DS. All I want is to pass a value to a Oracle table and get back the lookup value.

can anyone help me please.

thanks
rasi


Edited by - rasi on 10/25/2002 02:42:22