DSXchange

Hi, We are using the Tivoli Workload Scheduler to schedule the DataStage jobs to run Daily . But the issue I am facing is, in TWS, Status of a submitted / Scheduled job stream is continuously shown as running state even after DataStage job got aborted We could not able to figure out the root cause o...

This is solved!!!!!!!!!

The issue is we have to do DB2 catalog command

Hi, I am unable to establish the connection of DB2 database from DB2 connector of DataStage. I have given the Instance, database, user name and password as well. When I do test the connection DataStage throws error message "Test Connection Failed" and "Db2 library could not be loaded&...

Hi, I am working on DataStage version 8.5 In my project we have to use both InfoSphere CDC and DataStage CDC. Can we establish a connection between InfoSphere CDC & DataStage CDC. Is the connection established between these is Generic or Native Please provide me some supporting links. Thanks, Vi...

Any one of the following will give the solution to you. 1. What is the line terminator of the sorce file. whether it is Unix style or DOS style. 2. define a character set map in Sequential File stage using the NLS tab to UTF8. 3. In the Incomplete column, select 'Replace' to pad a short column with ...

Use the Description property on the Columns pages within the output stage to parse the sequential file into XML document

chulett, No chance

Hi Ray,


But my job is successful with the fastload optins and i want to know are the delimiter i am giving correct or not.

please suggest.


Regards,
Viru

Hi, Source is sequential file with TAB as delimiter and Target am using Mload stage. I am trying to load the data with data format "VARTEXT" and Tab Delimiter as TAB or \t . But getting an error msg "UTY4016 Data item too large for field BP_RELTYP in vartext record number 1" No d...

Hi, I have 3 parameters in routine and i want to use these params to use inside routine. 3 params: src dir , filename , tgt dir My expectation: Move c:\ak.txt c:\tgt\ srcdir = c:\ filename = ak.txt tgtdir = c:\tgt I want to make use of this command MOVE and wanna move the files. Please post the exac...

Hi, One of my job is failing while loading into target, I am using Teradata's MULTILOAD stage and in that I am usng LOAD method as a VARTEXT. I have delimited TAB in the source. I tried replacing with 009 and 9 and ' ' and \t. But, I am not sure on what else to be doen for this. Does some other sett...

Yes Ray, I tried in different ways like, i wrote the BTEQ script in
Custom SQL
Before SQL
After SQL
Using API and MULTILOAD stages

Also i tried Before and After Job subroutine with ExceDOS in the job properties.
But nothing is worked out

Thanks
Viru

Hi,

We have a Teradata BTEQ script, working fine in windows Environment,
I want execute the same through Datastage. Please any body suggest me...

Can we execute this script from Before and after Sql in Teradata stages.....

Thanks in Advance.

Assign the roles to the Admin or Operating System credentials must match to use the datastage

HI go4it,

I tried all those ways. But i could not able to connect to the server.

My doubt is How the client recognize the server with the port 9080. Is the set up is requried either in the server or client.

Thanks,
Viru