DSXchange

Hi

I m using Teradata API for updating a teradata table values from a sequential file but not able to figure out how to specify both incoming file and updatable table in the API stage as it allows me to specify only 1 of them in the input tabs.

Thanks
Amit

Hi All

i have to subtract/add one/or more days from current date in transformer stage.
wht is the function or proper syntax to do this in datastage PX.

Thanks
Amit

Hi

What would be the best way/stage for UPDATION logic in datastage for Teradata tables.
Shall the UPDATION done out of datastage using teradata database or
can i use any other stage from datastage as no update property is provided for TERADATA ENTERPRISE in Datastage PX.

Thanks
Amit

Hi Amit, Do a search on Modify stage. Modify stage uses direct orchestrate functions. Search the Orchestrate manuals and you will find the orchestrate functions to be used in Modify stage. In this case it will Date_From_String HTH --Rich Hi Thanks for the help.It works. Can you suggest me where to ...

Hi I tried using Modify Stage for converting varchar to Date using below conversion specification : new_date : date = StringToDate(old_date,"%yyyy-%mm-%dd") But it gives error saying : main_program: Error parsing modify adapter: Error in binding: Unknown conversion: StringToDate Expected d...

Hi All

Can some1 explain the use of CFF stage citing example from practical implementation.

the scenario in which complex flat files are used along with example of a CFF.

Thanks
Amit

Hi All

Could any1 plz let me know if there are any books or reference material available for new Datastage Enterprise Edition Parallel Extender Certification v7.5 exam that was launched in Feb 2006.

Thanks
Amit