DSXchange

FIELD1 FIELD2 FIELD3 A B C D F G I NEED TO CONCATENATE THIS FIELD1,FIELD2,FIELD3 AND SEPERATE THEM WITH - EXAMPLE OUTPUT 1. A - B - C 2. D -- F 3. G-- 1. THE PROBLEM IS OUTPUT ONE IS IN THE CORRECT FORMAT 2. OUTPUT TWO I NEED TO FORMAT TO D - F WHICH I HAVE DONE IT BY USING "CHANGE FUNCTION&quo...

Hi DSGuru,

source-->transformer1--->sort--->transformer2-->hashfile

i am doing a sort on version.

Thanks in advance

DSguru2B wrote:Ok. This will get us no where. Did you pay attention to what Ken had asked?
Also, i am still waiting for your job design and what exactly are you doing in it.

The column is defined as varchar only.

DSguru2B wrote:Dont change it. Specify that column as varchar. Or you will lose that data.

I have one record i.e A1 which is creating problem.

version

A1
00
01
07

how can we convert this nonnumeric data(A1) into numeric.

thanks in advance.

DSguru2B wrote:Need to know your job design. What exactly are you doing?

Hi All,

i am getting this following error message

DataStage Job 542 Phantom 27961
Program "JOB.321231104.DT.1405157533.TRANS1": Line 137, Nonnumeric data when numeric required. Zero used.
DataStage Phantom Finished

can some one let me know how to resolve this.

Thanks in advance

Hi DSguru, how to get prevBook and preversion. Thanks in advance So let me make sure i got this straight! for 1-100 you are missing version 1 and 3 and for book 1-200 you are not missing any version. So you have to output 1-100 0 1-100 3 for the data sample that you gave. Correct? Or you just have t...

Hi DSguru, If there are out of sequence then i need to bypass them( i mean i need to throw of the entire 1-100) if it is in sequence i need to accept( i.e like 1-200) Thanks in advance. So let me make sure i got this straight! for 1-100 you are missing version 1 and 3 and for book 1-200 you are not ...

Hi DSguru, I have 8 fields in my source table. For each book i have different version.(book and versions are my field names) for example book version 1-100 0 1-100 2 1-100 4 1-200 0 1-200 1 1-100 2 i need to check the version number for a book are missing a sequential version between min and max. Ho...

Hi DSguru, The conditional operator is and here. Thanks Well there are several ways. Try using the search facility as well. Try this post as well. Also, you need to provide more info, is the conditional operand suppose to be and, or ,either or with the lengths of x,y,z. To split a row into mulitple ...

Hi All,

I am concatenating three fields say x,y,z
if length of x,y,z is greater than say 10 bytes, then create multiple records with 10 bytes in each record.

can some one let me how to solve this.


Thanks in advance.

Hi DSguru,

The other columns are going to be duplicated.


Thanks in advance.

DSguru2B wrote:So whats going to happen to the other columns. Are they going to be duplicated as well?

i have more than one fields. can you tell me how to proceed. Thanks in advance If its just two columns coming in from the source file then you can do it by building a small routine that takes in two arguments. Something like x = Trim(Arg1) y = Trim(Arg2) Ans = "" For n=0 To y Ans = Ans:x:&...

Hi All, i have two fields x y 100 03 200 01 300 04 400 08 my problem if i find a value 03 i need to create a 00,01,02 i.e 100 00 100 01 100 02 100 03 if i find a value 01 i need to create a 00 i.e 200 00 200 01 if i find a value 04 i need to create a 00,01,02,03 if i find a value 03 i need to create...

Hi All,

How to check if,The numbers are missing a sequential numbers between 1 and 10

EX: if 1 2 3 4 6 7 8 10--> skip record(reason is they are not in sequence)
if 1 2 3 4 5 6 7 8 9 10---> accept record.


thanks in advance

I have two tables 1st one is main source, i have a field x in that. 2nd one is a look up , i have a field y in that. Both the datatype and length are equal. my 1st problem is, if the record exist in x, and if the same record exist in y then i need to write to write to a flat file .how to implement t...