DSXchange

Hi Ray, It looks like DB2instance variable has set as DB2 and I can see the instance appearing in the DB2 database tree structure. The error just pops up when I first log in the workstation. It has not stopped my working so far. I modified DB2intance variable name a few times to try getting ride of ...

Hi All, I have installed IS 8.5 with one error occurred during the installation. com.ibm.is.install.exception.InstallException: CDIIN4358E: DB2 could not be started: db2start returned an exit code of -1. I let the installation go through. But when I login to my workstation, an error in the title pop...

Hi,

Just to double check with you for Vince's #4 of the list.
CRC32 is not Parallel job function but a server job function.


I have used this function in server jobs. But I can not use this function in Parallel jobs.

Thanks,

Hi All,

Thank you very much for your reply.
I will try the options Vmcburney has mentioned here, which are exactly I am looking for.

I will post any progress regard to this topic.

Appreciate for all your inputs.

Thank you for your reply, Madhusds.

InfoSphere CDC needs to purchased separately and is not a component of InfoSphere Datastage, is this right?

If we will not going to purchase InfoSphere CDC, is anyway to implement CDC in PX job?


Thanks,

Hi,

I have done Change Data Capture in Server DS job, ver. 7.5.

I am going to do same for Change Data Capture in Px ver. 8.5.

Does anyone have experience how to do so in PX? Please give some instructions on this.

Appreciate for your help in advanced.

Thanks,

Thank you, Ray.

Thank you all.

I was thinking to use Basic Transformer but it doesn't appear in the Palett.
I am not sure that it does not work or anything else wrong.

The convert function, Vinoth moentioned below, works now at least.

Thanks again.

The input string could contain any characters. The return should only contian intergers.

Samples are following:

1234.56--------------------------> 123456
123-456-789---------------------->123456789
ABCD(12-34+ "345")----------------------->1234345

Thanks,

Convert Function would not do work.

Input Output
-----------------------
"1234567" 1234567

Hi
I have used Server function Oconv to retrieve numeric values from the string input.

Oconv("John Smith 1-234", "MCN")

How can I do the same thing in Parallel job?
Anyone knows how to do so?
Thanks in advance.

DS version: DS 7.5.2 E.E

Billy

I am posting this topic to seek the best practice of DS jobs back-up. My current situation is to back-up DS jobs daily by manual. This takes a lot of time everyday. I am wondering that if anyone uses automation process to back-up the DS jobs. If anyone uses automation process, for example using scri...

Hi Everyone, Thanks for all valuable inputs. This issue has been solved now. The details that we did here are: The source data field is Varchar. The target file we produced is defined as Char field. The Char(0) charactor was padded in the ETL processes because the Environment Variable used for paddi...

I have tried all TRIM functions but none of them works.

Does any one know how to remove the padding charactors like 0x0 from a string?

Thanks in advance