DSXchange

I have gone through the link but it looks there is some problem with the DataType. but here is the Unedited error
"Unable to bind a pointer to a database field `RPT_D' to type DATE."

Thanks

I am just updating the Date Feild with a simple job as given below

DB2------------Copy---------DB2
Select * Update Statement

I am getting the below error ""Unable to bind a pointer to a database Feild"

Please let me know your thoughts on the same.

Thanks

Hi Chulett,

Can you tell me how to cat the value to the Stage Variable

regards,

Can you tell me how to cat the value to the paramter value

Hi,

I have to capture a value in the table with 3 coluomns and pass the max value as parameter.


Can you please tell me how to proceed.

Thanks

We normally run the Tivoli script in our Web Based Software Deployment for getting the jobs compiled in the new Environment.

But I do get the Data of '97 so if i am derivation as provided.. it iwill again give me the wrong output even if i set the Env variable to 2000.

Thanks for your reply

Hi, I am trying to convert a character date, format: MM/DD/YY to a date, format: DD/MM/YYYY In Server Edition, this was easily taken care of using oconv, but now tht we are moving onto EE, I am having difficulty. I tried the following: DateToString(StringToDate(Trim(lkDatesStripped.DataOut), "%...

that will not give the records. It will give the word count i believe

thanks siva for your quick respose

tried to know the total count of records in unix for the .ds file at unix command prompt. I am getting the following error. How can i solve this problem :) "ld.so.1: dsrecords: fatal: liborchsun4.so: open failed: No such file or directory" Killed I can see the file physically present in th...

how should i do that....

you can create the env variable under user-defined category either in the job properties option or in the DS administrator and can pass defalut values during run time.

Thanks for your reply vmcburney...i could get good knowledge from your explanation about data validation.

but why do you we need file level validation and how do we do that using the stages in parallel extender.

you can veiw data in the data set using dataset stage of dataset manager in datastage manger menu.

my main aim is to know why we do validations in file level as i know checking the validation of the data for nulls, correct format, alpha characters in the numeric columns.

I hope it is clear.