DSXchange

Hi ssnegi,

Thanks a lot for the reply. I am using DS 8.5 server edition. OS is windows 2003. VMware servers. I can not use Filter and look up stages.

Thanks,
bharathappriyan

Thanks a lot Andy for formatting the data.

Please provide your suggestions and let me know if you need more details.

Thanks,
bharathappriyan

I have a table called Employee. The key columns are EmployeeId and Emprec. Each employee reports to a position based on Effdt. There is a column named position_nbr. By joining reports_to with position_nbr, i can get employee's supervisor. The employees supervisor subject to change with employee as w...

Hi,

Could you please check the data type of the column in the file and in the hashed file?

Hi, i am using odbc stage to extract data from netezza table using select * from table name. Due to improve the performance, i need to set value for one of the variables in the same session where the select query runs . i tried with open command. but it is not working. Is there a way to achieve that...

hi,
I wanted to deleted the jobs.

Hi,

Thanks for your reply. The version is 7.5.2.

Hi,

I would like to delete the category and redeploy my code. Instead of doing this manually, i am planning to automate this. Is there a way to do that?

Thanks.
Bharathappriyan

Hi,

The job has a source table and target sequential file. It is one to one mapping. If there is any data in the table, the sequential file should be created. Otherwise, the job should not create an Empty file.

Is there a way to handle in the job?

Thanks.

Hi, In my job i am calling a stored procedure and it is running fine in one server. The same job is giving the following error if i run it from other server. The same database is used. Error: ORA-12154: TNS:could not resolve the connect identifier specified Please help me out to resolve this issue. ...

Please use user defined SQL with cast function. The syntax is given below.
cast( '22-Aug-2003' AS varchar2(30)

Hi,

I want to call windows bat file from unix using Autosys. I would like to know how to do this? Please advise.

Thanks,
Selva

Hi, I am facing problem to read hash file using UV stage. I am new to Datastage and learning the functions available. Please help me out how to read hash file through UV Stage. It is asking the Data source name. I searched the details. But i couldnt understand. Please forgive me if am wrong. Thanks ...

Try with &Hfd as delimiter in the target sequential file stage

Hi,

Please try with Data format as EBCDIC.