DSXchange

Hi !

I run Job sequence and transfer to job parametr defined as Date type
The value of parametr is 2005-07-12 00:00

The sequence abort with :

DSSetParam(StartDate), code=-4
[ParamValue/Limitvalue is not appropriate]

Why . Is it format of Date type of Datastage ?

In your solution your assume that the Cols type is integer .
It seem from my example. And if it strings if there any way to do it ?

I got it . Thanks !

How I can process the multiple lines in transformer returned if I use UV stage as the reference ?

Sorry ! I got it . Thank you all !!!

If I run SELECT VOC WITH @ID LIKE ...TMP... I get message
"10 rows was selected to SELECT list #0"

I try to use #0 as list name to delete it I dont succeed

Can you help me more , ArndW !

Hi !

If any way to run DELETE.FILE for files that contains 'TMP' string on thier name ?

Its not the case . The file is dynamic and I write his name right.

Any other ideas ?

Thanks anyway

i am trying to get multiple lines with two fields of key and I have three key fields at all.

Hi !

I need to do looukup into hash file with two keys and I try to use sdk rotine UtilityHashLookup.

How to concate two keys for this routine ?

How the keys are separated in hash file ?

Hi ! I need to perform folowing task Table 1 : id Col1 Col2 Col 3 1 2 NULL NULL 1 NULL 3 NULL 1 NULL NULL 4 I need to group by according ID and to create one row in target table : id Col1 Col2 Col 3 1 2 3 4 I there any STAGE to do it fast ? It seems the task is something opposite of task pefomed by ...

I run UPDATE>ACCOUNT and it seems all ok .
When I run COUNT 'DSLink2'
I get "Uneespected sentence without filename"

and "Scanned comand was COUNT 'DSLink2'

any ideas?

The answer in description of DSRunJob routine

Hi !

If any DS command to validate job and get if the validation is successfull.

Somthing like DSRunJob ...

It doesnt work .

i try two yours options from Administrator And I get message thet "SELECT" or "COUNT" not in my VOC