DSXchange

Hi All, I have a DS job whose output goes as input to QS job... DS Job: OCI---->TX----->Sequential File(Fix length) My Oracle table contains special german and scandnavian characters...If i do a select sql i am able to see them in Oracle which I think rules out that Oracle is not compliant...My NLS ...

Sorry for that Ray,
I understand you completely...I revoke my words...but if anybody have the solution pls do help me..

Thanks,
Saad

Dear All, Its really urgent...Now i have some special characters coming in my input file and my file definition in QualityStage doesnt allow me to see the special characters when I view from QS...the special charcters are replaced by the next character and hence the alignment is ditorted... Please s...

Hi, In my database table umlaut is entered and displyaed correctly....Its just that when I try to store the data into a CSV file...it is not dislpyaed correctly...do i have to do something in the job...but if i manually save the target file as UTF8 instead of ANSI, I am able to see it correctly in D...

Hi,
I am not getting an ODBC error...but I dont see umlaut in my output csv file...it appears as "?"...Please suggest me as to how do i see umlaut in my output file...

Saad

Hi,
I have a similar problem....Can you please suggest me how to output data into UTF-8 format....I want a csv file as output which should be in UTF8 format and not in ANSI....How to ensure this in DS job.

Thanks,
saad mirza

Thanks a lot everyone....I was able to resolve the issue using Geomatch as Ray suggested...In future ,i will definitely keep in mind to provide the exact scenario of the issue so that i get a more precise solution..

Thanks,
Saad Mirza

Hi, I am not able to format the extract according to my requirement...I want in the duplicate output as Duplicate record from File A and the matched record from file B one below the other in the same file. How do I achieve that....I select in the extract output for Match and DupA as the output file ...

Thanks Ray, I understand your solution...but the requirement is that any employee Re-hired would be required to give his old employee number and not a newly generated unique number...how do I resolve this requirement if I use sequence since i cannot use already used sequence again...correct me If I ...

Hi,
Yes also if the performance is hampering, can I get a solution using DataStage...How do we design such a job without considering performance aspects...
Please provide me with your valuable suggestions.

Thanks,
Saad

Hi, I have included the fields in my Block Specifications...Should I use the same set of fields in the Summary of Match Commands??If not then what is the use of Summary of Match Commands...Here we only define the cuoffs if CHAR comparison is used...So how do i proceed..??Should I define each field d...

Hi, I am trying to run a sequencer for a datastage Job...I am not able to compile the sequencer...I am not using any Parser or XML packs...I am new to DS..I am getting the following error..Please let me know where exactly the error may be... <JobSeqGenError> <Code>2017</Code> <Desc>XML parser error ...

Ray,
I searched the file but it is found nowhere on the server....

saad

Hi Ray, I tried increasing the cut-offs and making it greater than what is appearing in the RPT file...but then also the record is getting identified as duplicate... My initial RPT file was showing wt. as 21.94 for a duplicate... I modified my pass and made the cutoffs as 22 and after running the jo...

I tried that option of renaming tmp by temp..the file is getting created but no text is displayed in the log file...

Saad