DSXchange

Hi Everyone We have migrated our projects from DataStage V8.1 on Windows platform to DataStage V8.5 on Unix Platform. Few of the jobs use ODBC stage to extract data from a Database. Same jobs (with same Queries) are being run on DataStage V8.5 (Unix Server) pointing to the same database (used earlie...

Thanks rjdickson and Ray for the responces... If my understanding is correct, the classification table/file defines to which class a token/word has to fall in. if no match is found it should fall under either of the following classes (lets name them as 'unmatch-class-set') ^ ? > < @ ~ 0 - / & # ...

Hi Every one We are trying to investigate and standardize names. In the 'Investigate Stage' (word investigate using rule-set ABC.set) for the name 'GULSAN A GROWER' the pattern genarated is '?I?' In the 'Standardize Stage' (using the same rule set ABC.set) for the same name , the pattern generated i...

Thanks Ray, I overcomed this situation by using server shared containers in parallel job. Thank you.

Please let me know the Equivalent property for 'contains terminators' (Column property in server) in parallel job.

Thanks & Regards
Rahul

IBM has provided a patch for resolving this issue.

Hi Chulett

This is the only info i have from the Admin team who have installed the patch :

fixpack_FP2_IS81_windows_8100-1

They say this is no way related to ODBC drivers. but yet the problem.

Please suggest.

Hi All, I have a job that loads a flat file (using the schema file definations) into SQL server 2005 using the ODBC connector stage. The job was running fine untill this new patch was installed on the server. I am receiving the following error : TgtMstrTbl,0: ODBC function "SQLExecute" rep...

Hi Ray, There is a sequence job that has two set of similar sequence of jobs, made to parallelly pocess files...and same files donot get processed from two different sets(which we can decide based on some entries) when i direct this file to run from another sequence, it gets processed successfully.s...

Hi We have a parallel job which has a sequential file as source The job is getting aborted with the fatal warning message : SrcReadDataSeqFile,0: Unable to open H:/PATH/SOURCE/IN/T24D14PTXT: No such file or directory. But, the file is present in the directory and for the file permission, the DS user...

Hi Everyone, We have requirement to migrate application from 7.5 to 8.1 , and it is server edition . Please guide me if any functionality of functions has been changed. please let me know what and all precautions has to be taken and what all steps need to be followed. where can i face bottlenecks. T...

Hi ArndW,

Sorry for the mistake, as you pointed that was a result of some different routine.

The issue has been resolved.

The code used some of the string functions which were not being recognised.

We recoded with simple logic removing the string functions used.

Thanks and Regards
Rahul

Hi ArndW, Pasted below are the warnings\errors am getting compiling the DS Job ================ Output from transformer compilation follows: ##I IIS-DSEE-TFCN-00001 08:45:45(000) <main_program> IBM WebSphere DataStage Enterprise Edition 8.1.0.5557 Copyright (c) 2001, 2005-2008 IBM Corporation. All r...

Hi I am calling an external c++ routine in one of my Ds job and facing compilation problems.... The routine is like : #include <iostream> #include <string> #include <stdlib.h> using namespace std; int ReadSplitConvert(char* FILE_PATH,char* FILE_PATH_WRITE,char* FILE_PATH_WRITE1) { ReadMainFileandPar...

Replaced the power function with a different logic, using for loop had resolved the compilation problems...

Thank you all for the responces....