DSXchange

I don't see a vector defined in your osh - just a Char(40). Your metadata needs to specify the size of the vector (which will cause a vector to be defined). Do this on the extended properties of the column - right click on the column definition and choose Edit Row from the menu. Thanks Ray. I think...

Hi,

I have a column DESC_ which has values like the below one

DESC_
-----------
ABC
ABCXYZ
XYZ
NULL
ZZZAAABBB

I need to append comma after every 3 character.
DESC_
-----------
ABC
ABC,XYZ
XYZ
NULL
ZZZ,AAA,BBB

Please hint me with some logic to accomplish this.

Many Thanks
MSR

Many Thanks for chulett and ray.

Make it nullable in the lookup. If you really want a non-nullable result, handle the null in a Modify stage after the lookup and make that field not nullable from that point onward. Thanks Chulett. But why we need to keep the primary key and the foreign key as NULLABLE? Just need to understand the ...

The Nullability of source and reference keys should be same. I mentioned in my first post that I managed to get the data moving with the help of modify stage. What I need to understand is why the foreign key should not be nullable? Also the handle null or nvl function will introduce a in-band null ...

1) The department id from the primary link is nullable while the same column from the reference is not-nullable. Lookup stage use these column and send the output where the department id from the primary input is mapped. The other columns from the reference link is changed to nullable. 2) The Lookup...

Source Employees: record ( EMPLOYEE_ID:int32; FIRST_NAME:nullable string[max=20] {prefix=2}; LAST_NAME:string[max=25] {prefix=2}; EMAIL:string[max=25] {prefix=2}; PHONE_NUMBER:nullable string[max=20] {prefix=2}; HIRE_DATE:timestamp; JOB_ID:string[max=10] {prefix=2}; SALARY:nullable decimal[8,2]; COM...

The LIKE operator in a Filter stage uses asterisk (*) as a wildcard. It's all explained in the manual. I don't believe there's any single character match available. The RegEx functionality of filter operator is explained in OEM manuals. When I tested the pattern match with oracle like syntax it wor...

What makes you think it supports Oracle syntax? Why don't you spell out in words what it is you are trying to implement? I'm not particular about oracle functionality. As Filter stage support LIKE operator on pattern search, just want to know how to go about the meta character (% and _) when they a...

Is there any way we have to add the ESCAPE option in Filter Stage Where property. I'm trying to implement the following oracle statement in Filter stage

job_id LIKE 'SA\_%' ESCAPE '\'

How to handle the '_' and '%' character when they are part of search sting?

Many Thanks
MSR

Hi, How can we say a job is CPU limited or I/O limited or Memory limited while we attempt to tune a job? How to monitor the usage of CPU, I/O and Memory? Datastage v8 have lot of performance reporting but v7.5 don't have such sophistication? What would be the possible way to collect the usage inform...

Many Thanks Chulett and Ray. It is clear now

Thanks Chulett.

------------------------------
|.......|.......|........... ->\n
------------------------------

Here -> is the final delimiter and \n is the record delimiter. Am I correct

When my final delimiter = none , the target file still have a \n at the end of each line. 1) Please help me to know how it is? 2) What is the difference it make if I set final delimiter = none. When I executed the job for both of the options, I can't find any difference in the target file. I'm sure ...

Thanks Ray. More specifically it refers to a syntax about the operator usage. For example the copy operator syntax is

copy [-checkpoint n] [-force]

. Can we use this commands in any shell?