DSXchange

Hi Ernie,
is it possible to omit null columns while generating xml file in datastage 8.1 parallel edition.I see from this post that it is possible in server.Can you please tell how it can be done in parallel job.In sequential file stage of parallel edition ,i can not specify delimiter and quote as 000

is it possible to omit null columns while creating xml from csv file in Datastge8.1 parallel extender? In the sequential file stage ,I can not specify quote and delimiter as 000 as mentioned in this blog.

< split from this post>

Hi Ray

I have installed the patch successfully. Now I am able to see the BDFS stage.

Thanks
Arun Kannan

I am also trying to find BDFS stage. I have read something in this link

http://www-01.ibm.com/support/docview.w ... wg21515617

I have tried this fix pack " fixpack_FP1_IS87_linux64_8700.ispkg ". I am unable to locate ispkg file. Anyone faced the same issue.

We are installing the IBM Information Server v8.7 in Linux. After the installation of db2, was installation, we got an error message in the pop up Error message: CDIIN3234E: Could not connect to database.jdbc:db2://localhost:50000/xmeta Has anyone faced the same error. If so please share your experi...

What are the default Support for B2B protocols and OAG support in the Datastage version?

After generating the second job, You can import he job into mapping spec in fasttrack, We have an option to generate the mapping spec into CSV. there you can merge the two separate jobs CSV into one. Now you can import this CSV in one mapping spec, Please let me know IF you have further queries. Tha...

Hi ray,

Could you please help on this??

Thanks

Hi Experts, As per my knowledge Oracle CLOB datatype is equals to LongNvarchar in Datastage. when i am trying map CLOB data type field from oracle to LongNvarchar in filed in Datastage i am getting unsupported data type error. I could not able to import metadata from oracle table because of CLOB dat...

Please follow below design TableA--->copy--2links---> 1.Table A output 2.Table A output goes to Funnel TableB--->copy--2links---> 1.Table B output 2.Table B output goes to Funnel Now the output from funnel contains both table A,Table B Data This is achievable in single job Note:Funnel accepts many i...

Hi, My project was migrated from 7.5 to 8.1. we have a job with bulidops which we created for specific business logic. This job running fine fine in 7.5 and failed in 8.1 showing with the error at buildop stage. what steps i need to follow while migrating builop stages form 7.5 to 8.1?? do i need to...

Hi Experts, i am getting an error when i am trying to sort longvarchar (99999999) filed. here is the fatal error from log: "Trouble encoding sort keys: Variable-length key "MASTER_KEYS" length too large (32779), limit is 32767" i defined field with longvarchar but i do not why jo...

Hello Ray I have deleted all the data from dataset and finally created a dataset with one record, Now I am getting an new error while using teradata connector stage. BRNZ,0: /apps/IBM/InformationServer/Server/PXEngine/bin/osh: symbol lookup error: /apps/IBM/InformationServer/Server/DSComponents/bin/...

Teradata connector stage error while loading the data to the target teradata table. I am getting the following error. BRNZ: [IIS-CONN-DAAPI-000083] Unexpected character found at offset 9 parsing parameter 0 (CC_DBStmtParamParser::getNextToken, file CC_DBStmtParamParser.cpp, line 245) does any one fa...