DSXchange

thanks, chuk

this is of some use.

Thanks ray, SELECT NAME FMT '40L' FROM DS_JOBS WHERE JOBNO IN ( SELECT OBJIDNO FROM DS_JOBOBJECTS WHERE OLETYPE = 'CCustomInput' AND EVAL "@RECORD<14,1>" = 'dataset' AND EVAL "@RECORD<15,1>" LIKE '%<<Data Set name>>' ) ; ray, Can you guide me on the DataStage Repository(what is t...

Can we find all the job names, which use a specific dataset.

sth like(for job name)
SELECT CATEGORY FROM DS_JOBS WHERE NAME = 'JobSeq_Prod'

I had the input VarChar field to have the special char which has Char(226) value and ran the job to check if the count was greater than 0. It did not recognize the record.
How do I check if NLS is installed.

I tried with the function specified but it did not work. It did not recognize the record

Hi All, I am getting the following warning. Why is this and how to avoid it. I checked the posts already but did not get a solution. Any help please Trn_Columns,1: Invalid character conversion found converting to ISO-8859-1, substituting. [nls/converter.C:830] In the transformer Trn_Columns I am onl...

Hi AndrW,

Why do u say
"DCOUNT(Lnk_Read_PHONE.PHONE_EFF_DATE,'-')#2 THEN 0"

It should be
"DCOUNT(Lnk_Read_PHONE.PHONE_EFF_DATE,'-')<>3 THEN 0"

Correct me if I am wrong