DSXchange

Hi All, I am getting the following error while inserting the data into a oracle table, by using the ODBC connector stage. Here Oracle table name= 'ALARM' Oracle Database Name =CATEGORY_DB' ALARM_Insert_ODBC,1: ODBC function "SQLExecute" reported: SQLSTATE = HY000: Native Error Code = 4,091...

I got the solution. Thanks vishal and ray...

But i need the sequential file name. How can i get that?

Hi, We have a requirement where we need to create a DS Job to extract data from Sequential file and load to Target (we need to create multiple target tables for different sequential files dynamically). The DS job is executed from script and also the input file name is passed as paramter to the scrip...

Hi All, I have ds routine to send an email with the attachment. I am using the DSSendMail routine to accomplish the task. I am getting the email as per the requirement .Now i have a new requirement to send the mail to the CC mailing address also. Do we have any options like to send to the CC people.

I am having a source file A with a data of one million records. I am loading that file through the sequential file stage SF_A In the sequential file stage SF_A I used reject mode as "output " so that I can direct reject records to a another sequential file SF_Rejects through a transformer ...

We have a multi instance jobs A,B,C called from a sequence SEQ. This sequence is triggered by the perl script. In the perl script we are passing the invocation ID as XY2.XYZA2.A2A3. Now in the director log we are seeing the jobs as A.XY2 B.XY2 C.XY2 We are not getting the jobs and logs as A.XY2.XYZA...

Thank you....
Finally got it.

Thanks for your help.

But how to pass individual value of counter each time to job (like 1,2,3,...7).
Say if count is 7, then how to pass 1,2,3,4,5,6,7(i.e 1 for 1st run,2 for 2nd run....7 for 7th run) values each time when job is executed

Hi, I need to implement a looping concept in one of my jobs. I'll be having a count value in a column in one of my tables.Based on the count value present, i need to run my job that many times in sequence. Say for example if count value is 7, i need to run my job 7 times, each time passing value as ...

Hi chulett,
I generated Xpath expressions from XSD only....

Hi, I have a requirement to extract data from XML file and load it to a tab delimitted sequential file. My design flow is : External Stae --> XML input stage --> Transformaer Stage -->> Sequential File stage. I imported the meta data,namespace declaration too. 1 row (XML file path) is coming as inpu...

My Bad......:( The approach i followed didn't worked. ArndW, My job is like extracting data from Sybase using DRS stage and directly loading to Oracle using Oracle Enterprise Stage. Except for these two, no other stages are used. You told to redefine the datatype as CLOB.But when i did so, it gave m...

I've followed the below approach.

I already created the target table with the specific column data type as 'LONG'. Now in DRS stage i'm reading it as LongVarChar 214748364. I just ran the job and will update once when it is done.


Regards,
Balakrishna

Hi, As part of building my job, I need to extract data from Sybase and load it to Oracle. I'm using DRS stage to extract data from Sybase. One of the source column is of LongVarChar data type with size 214748364. With this i'm facing error as " Error occurred during link open processing. DSLink...