DSXchange

Dear All, We have a job which maps to two targets. But because of after inserting each targets we have to insert and update a log table and a control table, we made each target with the log and the control table into one Container. So Cont1 for Target1 and Log table and Control Table, Cont2 for Targ...

Hi Craig, I am very new with DataStage Basic, and a bit confused with the way it works. In Job1, I put OCI Stage => Transform Stage => Seq File stage The Output of OCI stage is the "Select Count(*) from Table", I put it into the StageVar and then to the Seq File. I want to re-use the Stage...

Dear all, How can I use a stage variable in a job control? In my case, I need to write some files, and the number of files will come from doing a 'select count(*) from table'. I designed my 2 Jobs, the first one is to get the count and run the second job based on that count. In the transformer, I pa...

Hi Ray, I just found out that the problem is in the source file. They are spool files without any delimeter, and the length of each row is 1001 character, so when we put them into the BLOB the size will be huge and the LongVarBinary datatype of DataStage cannot write the data to the seq. file becaus...

Hi Ray, Actually, the MXOC Conversion works OKAY with BLOB data. I found out that before the source file can be put into the BLOB, that file has to be converted into UTF8 format. The funny thing is that, if we converted directly all of the source files into UTF8 before inserting it into the BLOB, it...

Dear Experts, We're having a big problem here everytime we want to write a sequential file with the data coming from a SQL Server 2000. The thing is,the operational application stores the data as rows in the SQL Server with BLOB datatype. And we have to extract the data first from the BLOB table and...

Dear all, When I read the Help menu, I find two usefull stages which are not installed on my pc. They are Join Stage and LookUp Stage. I tried to find them on the CD, but cannot find them, and also tried to download them from eSupport or Ascential site, but they are not available there. How can get ...

Thank you very much Ray...
I'm using the Link Variables, seems like easier

Thanks again

Regards

ND

Hi, I'm new to DataStage. I'm trying to detect the new records that coming from one data source. I have file A with key DSA_ID. I have table B which consist all the records with unique key that exist in the system, the key is also DSA_ID. I try to use transformer stage to do this, but the problem is...

Hi, How can I use Folder Stage to read Text File data sources? I put some TXT file on a folder, all of them in the same format but come from different systems. I've tried to use it and connect it to Seq File Stage, but it didn't work. I looked at the XML Samples, seem like the Folder Stage only work...

Klaus, I think I'd given a bad example. Let's say on the job I have Transform Stage and Container Stage. How can I control the run of the stages? Let's say I want the Transform Stage to be run after the Container Stage run succesfully. I understand exactly what you meant, but that only applicable fo...

Dear all, How can I control the process of Stages that I have inside a job. Until now I only know that we can only control the process of jobs through Job Sequencer, or control the process of Output of Transform stage. In my case, I have 4 stages in a job, Transform-1,Transform-2,Transform-3,Transfo...

I'm using DataStageXE on Win2000. How can I activate the National Language Support so that our data can be keep in our local language (Thai)?

Need help on this matter.

T.I.A

ND

Regards

ND

I have a seq file data source which has 103 columns. Some of the columns (99 cols) are data with the same type (Revenue) but named differently (Rev_Jan_89, Rev_Feb_89, etc) I am using Pivot stage to make all 99 cols become 99 rows of Revenue data. I managed to do it for the Revenue, but I also need ...