DSXchange

Hi,

Isvalid is giving 0 for all the dates



this 12/34/2006 as well as this 01/01/2006

I am reading the date column as varchar but not as date, then will this syntax work IsValid('date',StringToDate(InputLink.Date,"%yyyy%mm%dd")) Use IsValid() function. If your input date is not in date format you might want to convert it and use - IsValid('date',StringToDate(InputLink.Date,...

Hi,

Could any one help me out in validating a date column of a CSV file .

the date format in the column is mm/dd/yyyy......

and i need to validate the date if it is a valid date or not.


thanks,

Hi , if the mapping is this way EXP------col_nm---- derivation---- colmnname inp.col1--col1______ inp.col1------ col1 inp.col2--col2______ inp.col3------ col2 inp.col3--col3______ inp.col3------ col3 why am i getting inp.col2 in col2 of output when i traced out the result.... instead of getting inp....

Hi,


Could any one explain what does partition do in join stage,

how can i disable the auto match in mappings , so that i can send :

say col 1:country into col b:surname .

What will be the date format if its currentdate()

or else DSJobStartDate ?

How to get the system date in datastage (parallel jobs)

Hi,


How to use the function DATE.TAG to get the system date in datastage (in transformer) ?


Thanks,

Hi,


Cans we sort or join the data taking two columns as key columns in Join stage and sort stage.

if yes what should be the property set.

thanks,

yes will try with SQL query...

But i would like to let u know that the error shown in directory is

"main_program: ORCHESTRATE step execution terminating due to SIGINT"

When i tried to pause the job.

thanku.

Hi,


why a job do not come into finished state (in Datastage director log file )while loading the data into data base from a sequential file.

I mean why it still shows that it is in running state....for a long time...
it gets hanged in that state(running)

thanku

I mean why it still shows that it is in running state....for a long time...
it gets hanged in that state(running)

Thanku

I got the reason..

Could you please tell me what could be the reason

why a job do not come into finished state (in Datastage director log file )while loading the data into data base from a sequential file.

Hi wat does this warning indicate:

"Transformer_16: When checking operator: Dropping component "Application_type" because of a prior component with the same name."

Application Type is column name

Thanks.

sorry i am new to this ..