DSXchange

I got it ,thank you very much prasanna for your input.

record {final_delim=';', delim=',', quote=none,padchar='#'}
(
name: string[max=255];
addres: nullable string[max=255];
street: nullable string[max=220];
road: nullable string[max=200];
)

No , it is in this format Row 1 of the file could be Key,Col2,Col3 Row 2 of the file could be Key,Col2,Col3 Row 3 of the file could be Key,Col2,Col3 or in this format Row 1 of the file could be Key,Col1,Col2 Row 2 of the file could be Key,Col1,Col2 or in this format Row 1 of the file could be Key,Co...

Hi From source we will receive 1 key column and out of 3 remaining columns only 2 columns ,that we are not sure which 2 columns out of 3 columns we receive. example if 3rd colums is not comming then we dont need to send those column to target.. thats way i mentioned all possible columns in schema fi...

Hi

From soure i have 4 columns and runtime i need to pick 1 key column and any 2 of those 3 columns.
file is comma separated only,Please suggest me how to do this.

Hi

from source we are not sure how many columns we receive and key columns should come definately and remaining not necessarily...
please suggest me how to do...

can u give one example how do u want to replace..

Hi All,

i am extracting data from source file.Here i am getting some special character those are like some box characters... How can i remove those special characters from the file.

Can anybody help me on this...

Thanks..

try this..
StringToTimestamp(DateToString(DSLink2.d1,"%yyyy-%mm-%dd"):' 00:00:00.000000',"%yyyy-%mm-%dd %hh:%nn:%ss.6")

Hi I have created schema file below format and i tried to run the job with 4 columns with data and it is working fine. i tried to run the job with 2 columns only but it is not running and it is throwing error for 3rd column delimeter is missing. can anybody suggest me how can i do . record {final_de...

Hi All,

Can anybody tell me what are all main architectural difference between Datastage v8.1, v8.5 & v8.7

Hi all, I am genarating fixed with file and that file contains 2 columns. Uniq char(4),Amt decima(8,2) Output file i am getting is : aaaa 000001.12 bbbb 000011.23 Required Output should be without space: aaaa000001.12 bbbb000011.23 The problem here is Before decemal coumn i am getting one extra spac...

Hi,

In the job we are giving 19 crore data to aggregator stage,it is taking 3 hrs time.here we are giving sorted data and hash partitioned data to agg and method in agg is sort method..please let me know if i can reduce the time in any other manner..

Thanks,
Rajashekar.

Hi All,
Can anybody te ll commnads to view the data in the dataset in unix.

Thanks in advance..

HI Ray,

Thanks for the information ,cant we do in the 8.1 version.Please let me know any work around.