DSXchange

Hi, Look for dsimport in the Manager Help Topics. Regards, Aedla -----Original Message----- From: Jeremy Jones [mailto:Jeremy.Jones@Hutchison3G.com] Sent: Tue 9/17/2002 3:32 PM To: datastage-users@oliver.com Cc: Subject: Importing .dsx files I have been asked by our support people whether or not it ...

I have been asked by our support people whether or not it is possible to import and process .dsx files via a script rather than by using Manager. Does anyone out there have any experience of doing this? Thanks. Jeremy Jones ________________________________________________________________________ Thi...

Please give me some more detail on the contract. Thanks Theo Pieterse -----Original Message----- From: battalio@dataWarehouse.com [mailto:battalio@dataWarehouse.com] Sent: Thursday, September 12, 2002 5:43 PM To: datastage-users@oliver.com Subject: UK datastage contract Hello All Anyone looking for ...

Stacy, Is DataStage Server running on a Unix or Windows server? If Windows, do you supply your userid/password or click "Omit"? If you choose Omit, try specifying a specific user/password (just your usual domain account). From my own testing, my firewall does not seem to indicate that there is a con...

The listener is unirpcd which listens for DataStage client connections on port number 31438 (by default). This number is not recorded in the services file on Windows platforms, instead it is stored in Registry. -----Original Message----- From: Stacy Scoggins [mailto:Stacy.Scoggins@kinkos.com] Sent: ...

All Unfortunately I have to do production support of the jobs that my team built, but the good part is that I get to do it from home!! I have DSL and when I VPN through the DSL modem, I can connect to DataStage each and every time. This weekend, I installed a DSL router so that I can share the inter...

System(99) returns the number of seconds since midnight Greenwich Mean Time (GMT), January 1, 1970. This may be more convienent for you to write something that is exactly what you require. The expected date format for DateGenericDaysSince1970 requires the date to be in whatever format your locale de...

You can use a folder stage or write BASIC code (job control) to open the directory as if it were a table (use OpenPath), then use SELECT to determine the "key" (filename) of the file in that directory. For example: OpenPath dirpathname To FileVar Then Select FileVar To 9 If @SELECTED > 0 Then ReadLi...

Hi, In one of my job I need to wait for any file in the Input directory. When the file comes in the Input directory by external process, I need to pass the file name to another DataStage job. Is there any DataStage function I can use to do this? I tried to use WaitForFile Stage, but that also needs ...

Hi, How abt simply using: (Iconv(16-09-2002,D-DMY[2,2,4]) - Iconv(31-12-1969,D-DMY[2,2,4])) * 86400 ? You could replace 16-09-2002 by Sysdate, but this is the idea. Regards, Aedla -----Original Message----- From: Jeremy Jones [mailto:Jeremy.Jones@Hutchison3G.com] Sent: Monday, September 16, 2002 8:4...

Javier, FYI - We are encountering similar issues to the ones that you describe in DataStage 5.2 at the moment. We encountered the out of order issue a few weeks back and Ascential inform us this will be resolved in the next version of the XML Reader/Writer stages available in version 6.0. It seems t...

This transform calls DateGenericToTimeStamp so your date may be in the following format: Any delimited date with Month Day Year, e.g. 4/19/1999, 4.19.1999, 4/19/99, 4.19.99 Alpha month dates, e.g. Apr 19 1999, Apr 19 99 Non-delimited date with Year Month Day, e.g. 19990419, 990419 Jullian Year Days,...

I need to convert incoming dates to seconds since 1970. I think I should be able to use DateGenericDaysSince1970 and then multiply the result by 86400. However, I am not sure what format the date supplied to DateGenericDaysSince1970 needs to be in. Has anybody used this transform? Thanks. Jeremy ___...

Much like David said, this is expected, or at least defined, behavior. The @-variables are designed to be a bit more static in nature. Determining the actual system time, ala the TIME() function, is a relatively costly operation in software operation. Because of this, the @TIME value is not updated ...

Hye ! Just a funny issue i experienced today... A routine called from inside a job control, before and after a job run, writes a timestamp in a log file. Classic, you think. Yes indeed. Here are some pieces of code used : =================================================================== * job cont...