DSXchange

Hi
It seems that you had a problem while connecting to database.
Did you check whether you are having proper entries in uvodbc.config file

Regards
RK

Hi All I am trying to read the number of row counts of source and target by a transform routine which was built by me , I am getting the correct results when i run the routine individually. I am facing a problem when i call that routine from a sequence. Problem description : I am receiving a warning...

Hi
Thanks for your valuable suggestion. I had done this and now i want to learn how to connect to a database from a routine. Can you please share the idea.

Thanks
RK

Hi
Thanks for your response. I want to update a table with the return value of a Transform routine. Can you share the syntax to connect to a database , for examle sql server through odbc connection

Thanks
RK

Hi All
Can you share some idea on how to connect to a database from a routine. I had a requirement that i had to write the return value of a routine to a database table.

Thanks
RK

Hi All I had a kind of problem , Kindly give me your valuable suggestions. There are lot of jobs under each folder/Category , I need Category wise list of jobs and the sequences as a report. I had tried to generate a report by compiling Multiple jobs option . but the output is not satisfying my requ...

Hi All Thanks for your response. I had tried to read the data from the table with another job and it is provinding all the information. Till now i am analyzing that there are some locking issue with the table , but now i am able to read the data from the particualar table . But when i try to read da...

Hi I am trying to view data from a DRS Stage table configured to connect to Oracle 10g database - I am encountering this error ---- Error calling subroutine: DSD.Browse (Action=3); check DataStage is set up correctly in project Dev_OP ---- After this message it is prompting " Data source is emp...

Hi Guys Some news from my end Fortunately i am able to connect to Oracle 10g Database where in i had installed Oracle 10g Client installed on the machine where Datastage server is installed. Thanks for the valuable responses. I had just restarted my Machine and now i am able to Connect. If you had a...

Thanks for your response Guys Datastage version is 7.5.1.A only i tried to connect through ODBC Stage and i am getting this error. --- DSR.MetaGeta(GET.TABLES)(SQLConnect('dsn','admin')): BCI Error: SQLSTATE=IM003,CODE=160,[DataStage][SQL Client][ODBC]Specified driver could not be loaded due to syst...

Hi Can somebody guide me to resolve the issue. I am trying to connect to Oracle 10g R2 using ORAOCI9 Stage and i am getting the following Message like " Unable to initialize plug-in: " I had tryed to access Oracle 10g R2 with DRS Stage also but i had the same Message " Unable to initi...

Hi Priya

Can you give some input on writing a code step by step to store the log details into a file.

thanks in advance
RK

Hi The advantage of using hashed file is that it will be stored in the server where the DS server is running . The turnaround time to read and write will be faster than reading/writing the data to database. Added to this there are some more advantages using Hashed File. Any one correct me if i am wr...

Hi Andrew Thanks for your prompt response i had tested it and it is working fine Added to this one more query suppose if i want to populate my reject table , which ever the records had equal like Column1 ----------- 1 2 3 4 4 5 6 6 7 ----------- In earlier case it is loading the data into target as ...

Hi Andrew

Thanks for your prompt response

i had tested it and it is working fine

Thanks alot

RK