DSXchange

ArndW wrote:What is the ODBC Data type for this column declared as?

The ODBC Data type for this column is VARCHAR(255)

After re-reading your initial problem statement a few times I realized you said that you hash sorted on the key. I'd also recommend hash partitioning on the key in the sort stage and then use partitioning "same" on the RD stage. Thanks for all the suggestions. I will try it out and post m...

There is only one distinct key value in the group If that's really true, and you have hash partitioned on that key, then you should get one row out. Because all rows will be processed by one node, irrespective of how many nodes there are in your configuration. If Monitor shows more than one node pr...

ray.wurlod wrote:The Remove Duplicates stage will return as many rows as there are distinct key values in your data stream.

There is only one distinct key value in the group

I am running a job on a grid and reading from a database and in a transformer I am splitting the input into mutiple outputs and in each output stream I am passing the key and a sub set of fields. I want to remove the dups in the stream based on the key (Keep last). However the remove dups stage retu...

Hi ArndW,

Thanks for the tip. With your help I could find out that the drive was not accessable.

Joseph

Hi Arndw,

I am sorry I should have explained myself better. I can view the file in UNIX when I log on with the user id and password of the account that I use for datastage. I would like to know what The list command that you suggested would do.

Thanks

Joseph

Hi Arndw,

Thanks for the reply. The drive is accessable to all users. As I had mentioned I can view the data in the file with View Data as well as in UNIX. I am however new to UNIX, Could you please explain what the UNIX commnad you suggested does.

Thanks

Joseph

I have a parallel job which should read a file which is on a windows share but mounted on UNIX on which datastage runs. When I click View Data from the Output properties tab the file opens and I can see the data. However when I run the job I get this message Seq_GHM,0: Unable to open /mnt/edw/infosy...

I have a stage variable which I defined as Decimal(38,28). If in this stage variable I divide 1.000000000000000000000000000 by 3.0000000000000000000000000000. I get an output of 0000000000.3333333333000000000000000000 instead of 0000000000.333333333333333333333333333. Some how the last 18 digits of ...

I have to split data from a TEXT field in SQL Server into strings of 72 chars breaking the string at a "Space" or "Enter". I am doing this in a Routine by passing in the TEXT filed. OK, you don't need SQL in the routine for this. FUNCTION Split72(TheText, FileName) SplitText = F...

In the BASIC.pdf it talks about it. Are you talking about SQL against hash files or Universe files or other databases. Most of the time this should be done in jobs. You lose the GUI viewing capabilities when you run SQL in routines. It sort of defeats the purpose of DataStage. Maybe you could give ...

Could you please let me know if there is any documentation on the proper use of SQL in routines.