DSXchange

chulett wrote:The target is what - another sequential file, database table? And the signs are leading or trailing signs? Also, are you sure they are all "missing" or is it just the plus signs? ...

The target is sequential file. The signs are leading. only the signs are missing.

HI all, I have a source file. I am reading the file using seqential stage,one of the columns has a datatype double and contains amounts with '+' or '-' signs. when i view the data it is showing fine, but after sorting the file using a sort stage based on a different key column, in the output the '+'...

Sorry for the mess.! Criag, from the next time I will try to post my queries as detail as possible!

If the records come in same order, then you can use a stage variable stgvar in transformer and reset the stage variable stgvar to zero if col2='x' else if col2='D' add col3 to stgvar, else if col2<>'D' or 'x' add zero to stgvar. Wish it were that easy. I just gave the value of header as '0' just to...

There are 45 other columns other than the two above so cannot use an aggregator

Thanks for the reply. I tried using the Aggregator stage and group by option but am unable to generate the required output.

Hi all, Can anyone of you help me out with the logic for the following Col1-------col2-----Col3 Header1--- X------ 0 Detail1 ----D---------1 Detail1------D------ - 2 Detail1----- D---------3 Detail1------C---------4 Detail1------D------ --5 Header2----X---------0 Detail2------D--------1 Detail2-----...

Hi , I have a requirement like this. Col1 ------> Col2 abc 1 abc 2 abc 3 abc 4 def 1 def 2 def 3 ghi 1 ghi 2 ghi 3 Whenevr there is a change in key column the value has to be reset. I achieved this using Stage variables. Now I need to take the max value generated by each key in a seperate column. Ca...

HI all,

I am using a stage variable to generate a sequence of numbers like 1,2 ,3 but in the output as 00000001, 00000002 .......... Can anyone help out in how to do this

Thanks guys! I was able to ftp to my desktop. Here is the procedure ( in case anyone in the future needs it) 1.open DOS promt. 2. Go to the root directory to which you want the file to be transferred (ex : desktop) 3. open ( asks for the server name you want to connect to , give it ) 4. enter your u...

Ray and Arndw thanks for your time

Hi all,

My datastage client is running on windows Xp and my server is on Unix. I have a file in Unix i need to open and see in Notepad. Can any one please suggest me a way to ftp from unix to windows desktop.


Thanks!
Marcus

Thanks a lot guys!! That worked

Hi all,

Can you guys let me know how to put a filler(all blanks) in the target sequential file(fixed length) that has to be of the size char(400). In the transformer what has to be the derivation?.

Thanks guys!

Hi,


Can any one help me on the logic for resetting the counter depending on keys on key partitioned data using stage variables.


Thanks,
Marcus