DSXchange

Hi Julie Cant you just join the table and file through a transform? Adam Julie.Jarrett@ing.com.au on 20/06/2002 03:30:40 PM Please respond to datastage-users@oliver.com To: datastage-users@oliver.com cc: (bcc: Adam McGuinness/NSW/QBE/AU) Subject: extracting more than 1 matching record from a table W...

When there is a case of needing all the records from a table that meets a certain criteria, is there any way of doing this. If you could do a join against the two tables that would be fine, but if the input is a sequential file, ??? then we would need to load this data to a table . Any other clever ...

Does anyone have ever try to use UniAdmin(Universe Client) with a DataStage Universe database on Windows?

Is this supported by Ascential?

Thanks

Christian

Dave, What we do, because we use a lot of lookup hashes (some large and some small), is that we refresh the hash file when we write to the Oracle Warehouse data. That way, when we go back to access the lookup info, we dont have to read back from the Oracle database. Im not sure this would work for y...

A colleague of ours introduced us to an interesting idea with jobs that use Hash file lookups whereby the Hash file could be refreshed from within the job. An example of the type of thing were talking about is as follows: [Database select] | | | [transform] | | | [Hash file lookup] . . . [Input Data...

For UNIX you can use the following code snippet, modified as needed for your site. SendToWho = datastage-users@oliver.com FileAttachment = /aDirectory/file.lst TheMail = "mailx -s" : Subj : " " : SendToWho : " < " : FileAttachment Call DSExecute(UNIX,TheMail, Output, ReturnCode) ** If zero then it w...

We are using Datastage 4.0. We are trying to figure out a way to e-mail
someone if a job fails. Does anyone know how to do this?

Mardi Wetmore
IS Database Administrator
OReilly & Associates
1005 Gravenstein Highway North
Sebastopol, CA 95472
Phone (707)827-7075

We have a complex query that extracts data from a Sybase 12 database to a flat file. This query takes different query plans dependent on input date range. Is there a way we can use something like set forceplan in the query definition to ensure a consistent query plan for each run. Using complex/mult...

Hi I define "performance" that how many record process in datastage" Exactly, In common sense, Data Volume (M/B/minute) is meaningfune measure. but datastage job handles data by record. so I used to use Perfomance measure as How many record process in second. I have supporting 10 more site using dat...

Hello Radha Ive tended to use the ftp utilities outside of the datastage environment using a text file as a controlling file. e.g. in DOS: ftp -s:control.txt where control.txt is: open targetserver.com username password bin This allows you to batch up your job and include any compression utilities t...

James, This was in our prior to DataStage days and we had to do a one time load of data in a PDF. What I did was used the plug-in to save the data as a text file. We then took a Perl script to cleanup the format. Finally we SQL Loaded the file into Oracle. -----Original Message----- From: James Lin ...

Shawn, So if I just save the file as txt or rtf format then load it thru Datastage. Would it work? Would you mind giving me more detail how did you get it done before? Thanks. James -----Original Message----- From: Shawn Ramsey [mailto:SRamsey@starbucks.com] Sent: Tuesday, June 18, 2002 10:33 AM To:...

James, I believe it was version 4, but I am having issues getting to adobes site to verify that. I think that they now use an online process to convert the files. Shawn -----Original Message----- From: James Lin [mailto:JCLin@vartec.net] Sent: Monday, June 17, 2002 2:45 PM To: datastage-users@oliver...

Better yet, the first thing you have to do is look at a job executing and see if the single CPU utilitization for that process is at 100% (suggest using a tool like top). If your job is at 100% on both servers, then its all about megahertz. DS jobs are single-threaded, so in theory it should utilize...

Hi All,

Is there a DataStage plugin to do secure FTPing like PSFTP?

Thanks,

Scott