DSXchange

Most times when I have a file with 2 or more differnt layouts, the file should have a record type indicator, something to tell you what kind of record it is. You can probably use this indicator in the Transform stage to direct the record though the correct layout and into the correct file.

I am in the http://developernet.ascential.com/forum ... category=1# and trying to download EtlStats20050215.zip but when the zip file comes down there is nothin in it. Does anyone else get this problem?

What do you mean by do a lookup, do you mean the lookup stage? I don't have that on my designer?

The only problem I see with this is if the AS/400 file gets large, I will be bringing the whole file though the ODBC connection to do the filter. I was looking for a solution on the output.

We currently do that in the transform stage, the code looks something like this:

Trim(DataTypeEbcdicToAscii(Recovery1ODBC.DataLine[60,1]))

Hello all, I am having problems with a job and would like to ask everyone's input. I have a job that extracts data from a SQL server and then places the data on a AS400 table. I only need to insert the data if it doesn't already exist. When you use the self create SQL you can only select insert or i...

Ok, I downloaded it and imported the dsx, now I am starting to set up the BuildJobStatusHash job, but the JobStatusSeq is looking for a specific file called #FilePath#Staging/JobStatusStg.txt? I can't find this file on the server?

I'll check it out, I downloaded it and there is a EtlStats_Index.html page, do I just go down the job list one at a time and create them all? You need to download EtlStats.zip from my tips page. It is a series of jobs which run dsjob -report XML and load the data into Oracle tables. The create table...

But then the jobs would have to load in order? There are a couple of processes that require the jobs to run in parallel? From what your saying is that I create a batch that runs each job, and then logs the errors if there is any? Hi, just like Arnd said - You can always add a piece of job that will ...

I was thinking about something where I could write the status of the job to an oracle table, then create a web page for a monitoring system, but wasn't sure if the best way was to put code in every job or if there was a system table or file I could extract the data from every 10 to 20 min or so. Ins...

Hey, I am kinda new to Data Stage and there isn't anyone with real knowlage in the company anymore, I took over monitoring the job and need to find a better way to do it. Currently we just go into Director and check each schedualled job. Anyone know a way to generate a daily report stating if the jo...

I keep getting the following Permission Denied error, other people can run the process except for myself? Anyone got any idea's ExtractSnapshotDate.CTransformerStage1: |ExtractSnapshotDate.CUvStage5.DSLink4: DSD.BCIOpenW call to SQLPrepare failed. SELECT "SystemName","SnapshotDate&quo...

Does anyone know if it is posible to start a DataStage Extraction job, from a differnt system? Example.... having a Java program execute an extraction when the Java program is called. I want to make the job event driven and not Date/Time Driven?[?]

I am new to DataStage and need some information, I have tryed searching the internet and looking for books, but can't seem to find anything on DataStage 4.1.1. Does anyone know where I can find something to help me get started?