DSXchange

Hi, I am using compare stage to compare two columns.Two input fields in two files. In the output column tab when i define the definition like first.col1 second.col1 first.col2 second.col2 as suggested in the documentation (PARALLEL JOB DEVELOPER GUIDE Pg34-1) like first.col1 its giving me the follow...

Hi Ray/Kumar,

Thank you very much for reply.
kumar i searched the IBM site . i couldnt get the orchestrate guide relevent to datastage
Ray can u give any URLs i can download and read it.

Regards,
Bala

Hi, Can anyone let me know where i can find about orchestrate operators?.Do we have any list where we can use it to build custom stages.When i went through the manual for building a custom stage i found that in the Operator tab of the custom stage,i need to specify the name of the Orchestrate operat...

Hi Istsaur,

Thank you very much.Its my mistake.In the property tab of the Addtional connection information i gave the connect string.I gave it in remote server it worked fine.Thanks again

Regards,
Bala.

Hi, I have Oracle 10g installed.I could able connect through Dyanamic RDBMS,ODBC and used the orchbutil utility to import metadata but i cannot view data through Oracle Enterprise edtion stage i am getting the following error. #I TOSH 000002 15:30:24(001) <main_program> orchgeneral: loaded ##I TOSH ...

Hi, Thank you very much for the reply.It really helped to understand the problem.Its solved. To answer your question yes my comp is in network(SMP). Kindly let me know Visual studio.net has so many components which part of it if i install its sufficient for datastage because i am installing all the ...

Hi, I am installing datastage.I have installed Microsoft Visual Studio.net 2003.When I use a parallel transformer i am having a problem in the compilation. I guess the problem is with the C++ header files.Kindly let me know which software i can download or install exactly to rectify the problem. Can...

Hi Usha,

Thank u for the reply.Only 1 row is passing through the folder stage to XML stage.Am i making a mistake in that first.

No warnings or error message in the director log

Regards,
Bala

Hi, I am extracting an XML source to a sequential file.I am using a folder stage as input to the XML input stage,defined the metadata through manager and loaded into a sequential filestage.No Errors no warnings. But data is not flowing from XML Input stage to sequential stage. Any inputs most apprec...

Hi, I am using change capture stage to detect the changes.I am using one field as the key. I am getting the following warnings 1)CL_DELTA: When checking operator: Defaulting "SRC_STM_ID" in transfer from "beforeRec" to "outputRec" 2)CL_DELTA: When checking operator: Def...

Hi, I am a using lookupfileset which has date and time values.I am using the field SRC_STM_ID as the key field to get the values.When I do that data is prpogating but i am getting the below mentiooned warning. LKP_CL: When checking operator: Dropping component "SRC_STM_ID" because of prior...

Hi ArndW,
Thank you very much for the reply.The problem is with everyone.Where can I find this dsenv file.I have tried searching it i am not able to see.

Regards,
Bala

Hello All, I am getting the following error when I try to view data from Oracle. ##I TOSH 000002 12:39:50(001) <main_program> orchgeneral: loaded ##I TOSH 000002 12:39:50(002) <main_program> orchsort: loaded ##I TOSH 000002 12:39:51(000) <main_program> orchstats: loaded >##E TOSH 000205 12:39:51(001...

Hi Kumar,

Thans for your reply. I am not having problem with making that enabled to edit.I am in the editable state itself but it is not allowing me to enter a partion number.

REgards,
Bala

Hi, I have generated one lookup fileset in one system.I have imported the same job in another system.I am getting the following warning and the job gets aborted. Below is the warning message. GEN_DT_TM_1_1.#0.XFM_DT_TM.TO_XFM_DT_TM-Input.TO_XFM_DT_TM: ds_ipcopen() - call to OpenFileMapping() failed ...