DSXchange

Hi Ray, As you said, I am trying to use a Bitmap array index to identify whether the random number generated is already present in the UniqueIndex . If yes then I should generate another random number till I find that the number is not an existing number...but I think, i wrote this algo keeping int ...

Hi Venu,
From which layer are you trying to schedule...?BW or DS? Which method are you using?PUSH or PULL? If you are using PUSH, are you trying to schedule using Process Chain?

Saad

Hi,
Ok....Can anyone guide me as to how to generate Random non duplictae numbers using Rnd() or Randomize() functions available in DS...

Regards,
Saad

Hi, Here is my code for generating Unique Random number keeping in mind that Rnd() function will not generate random number twice...I have distinctIds file which contain already used Numbers...if the number is present in the file then this routine doesnt generate that number again... but if distincI...

Hi All, Now I am able to Match the Special characters between 2 files...If there is a match found I extract the duplicates into another output file.. My problem is that the output extract file does not display the special characetrs correctly...Again this output file is an input to DS job ... Please...

Hi,
If i understood u correctly, you mean that even though the view gives you different alignment but the Job will give propoer results...I even tried that...I ran the job witht the same file but eventually I dont get the match for the words which contain special characters..

Regards,
Saad

Thanks Arnd and Ray,
I think you are right...anyways thanks so much for your help.

Regards,
Saad Mirza

Hi, Yes you are right ...The character is displayed correctly in my outputfile...but my QS doesnt take that as input...it doesnt recognise umlaut...the special character just disappears and the place is take by the subsequent character...resulting in a distorted format... Please suggest.. Regards, S...

Hi Ray, If I keep NONE as NLS in DS job..then my output file shows correct characters...But that outputfile is an input to QS job... When I see the file through QS server output files option avaialble when you right click the QS Job...I see the data distorted...and the special character dissapears.....

Hi Ray, Actually my question is related to my Post in DataStageServer edition group where subject is ..Unable to decide which NLS to use and where...since my output of DS is an input to QS...and my output of DS is a fix length file with ISO8859-1...If I use UTF 8 then the output is distorted..and if...

Hi, Interesting!!!!Yes I am working with Ascential parallely on this issue...I trust this site more than Ascential Support...Ok..to your specific questions..I am not a QS expert...I am a SAP BW expert...:Suddenyl the client decided to have QS for certain activities...and within short period of time ...

Yes ..It is showing me length as 1..

Saad

Hi Wolfgang,
I do not see German characters in my output of Datastage...

saad

Hi Wolfgang, Ans 1) Yes I am able to read the special chracters using SQL select statements Ans2) I created a job using Input OCI and output Sqequential...my output is fixed lentgh format file..I dont see special characetrs in my output sequential file.I open the file in Notepad editor.I open other ...

Hi Roy, I have a similar problem...I am not able to use Quality Stage with German/Scadinavian special Characters...My QS output is a UTF 8 format fixed length file...when i view it in QS the input file alignment is distorted and umlauts are replaced with space and the susequent columns are distorted...