DSXchange

Hi, In my job I am using the target as the Teradata Eneterprise stage. Source as a dataset. In source one of the column is varchar 5 and having the values 12345 In the target aslo i have the column with the same Varchar 5. After running the Job Teradata column is populating with ????? values Can any...

Are you 100% certain that you have precision (length) and scale in the correct columns? Can you post the record schema that you are using? DataStage seems to believe you are using precision 2, scale ... Hi Ray, I was used reversily in StageVariables.That's why it was throwing Error. I was used earl...

Hi I have a field which is the type decimal type having length 15 and scale 2 having data ex 0000000000000.11 it has been defined same in all the stages. But when I am trying to compare it is throwing error as ##W TFCP 000000 11:35:55(001) <transform> Error when checking composite operator: The numb...

Hi, In one of my Job I need to add exactly 3 months days to the existing date. Suppose if the Incoming date is coming as 2007-01-01 then output date should be 2007-04-01 So for this I can use MonthFromDate function to extract the Month from the input date and adding 3 value for that doesn't give the...

Teradata is not allowing to change the timestamp to the lenght of 19.

Changed as the Varchar type. Now job is runnig fine

Thanks

Hi I am trying to populate some data from a dataset to teradata table. In the dataset there is a filed 'AUDIT_TIMESTAMP' with the type Timestamp. But at the Teradata the field is AUDIT_TIMESTAMP Timestamp 26(Length) 6(Scale) is taken. After running the Job I am getting the following error. Corrected...

[1] Did you export both the Job Design/Executable together or [2] Did you export the Job Design first followed by Job Executable into the same .dsx and forgot to say 'append to the ....' option. This would result in you losing the job design. Just another thought Now i am able to edit the Job. Than...

DSguru2B wrote:When you exported the job, did you export the job design as well?

Yes i exported the executables of the job along with design.


Regds

I was trying to import a Datastage job which I had exported. The import was successful and the job is appearing in the repository. But when I try to edit it, it throws the below screen saying " This Item has no deign time information". Please could anyone of you tell me what could be possi...

Do you have some other job that works well with this database? Can you read some data from the database using Datastage(try an Oracle stage with an output link and then click view data)? Can you connect to the database from the Datastage machine using SQLplus? ORA-03113: end-of-file on communicatio...

Hope data type of the JobActivity's parameter is also string. Yes type of the parameter is same in both places. For clear understand i am giving here the error. SEQ_Type2_Dimension..JobControl (@AAA): Controller problem: Error calling DSSetParam(LastModifiedDateTime), code=-3 [ParamName does not re...

Hi, I has a Sequencer Job which has a routine to pick the LastUpdDatetime from the hashed file. it's working fine. My problem is it the picked value should be passed to the JobActivity. To do this i created a prarameter at the Job properties. I defined a parameter called mofieddatetime with the type...

Hi, I was developed a job in server edition where i used to get the max date from the universe file by passing the Job name as the paramter. i have imlimented some thing like Max(upd_dt_time), and job name will be populated into the hashed file. by using a routine i used to pass the job name as the ...

I am just beginner of parellel jobs. when i am executing the jobs, jobs are running properly and records are populated into the target.

But i am not getting performance statics even though it was enabled.
What could be the reason.

Hi,

Can we use Oracle Procedures and functions in Datastage.