DSXchange

Hi Wolgang The reason I need to do this is that I have a series of slowly changing dimension tables that all require the same logic applied to them for each load on the same SCD columns in their respective tables. However, the primary and natural keys for each table have different names. Hence if I ...

True, but the setting you are referring to relates to the client timing out and the default setting of 3600 seconds is 60 minutes. It has no relationship to the FTP stage and wouldnt explain the 30 second timeout. Stacy Scoggins -----Original Message----- From: Don Hines [mailto:Don.Hines@Vivare.com...

The server may be timing out. By default, the connection between a DataStage client and the server times out after 3600 seconds of inactivity. To change the default: In the DataStage Administration window, click the General tab to move the General page to the front. In the Inactivity Timeout area, u...

All In an FTP stage,I am using a TELNET BEFORE COMMAND to call a script that extracts a file from a remote server (because the DBA wont allow direct access and has a script to extract). After the extract script runs in the TELNET BEFORE COMMAND, the file is FTPd to the DataStage server. The extact t...

This is a topic for an orphaned message.

This is a topic for an orphaned message.

Fellow DS users. Im running DS 5.2 on AIX with Oracle 9i and Im getting the above Oracle error intermittently. Ive come across ORA-01555 it a previous life when Ive tried updating a table that Im also querying, but never when the only transaction happening on the offending table is the select. The D...

Hi all This issue is finally resolved, and it boils down to the fact that the .odbc.ini file needs a serious lack of commented lines in order to function properly. A support rep from ascential asked me to remove all the comments and try the connections then - it worked. It turns out that it was a bu...

Hi Adam, You could try creating a view over each of the tables with a common set of column names and then have DataStage load the view. You can use a parameter to for the table/view name. cheers, Gavin Gavin Cooke www.altis.com.au > -----Original Message----- > From: amcguinness@qbe.com.au [mailto:a...

Hi, Why not use the FTP stage. This will read and write seq files on UNIX and NT platforms. One of the great things I find about the stage is that you can read and write specific formats. Eg: Read seq with delimited fields using pipe / Write seq using fixed width Stewart -----Original Message----- F...

I have not done this but I would suspect that you could use the UNC name for the share (serverdatafilename.txt). The other way would be to do a net use (net use e: serverdata) command to map the share to a drive then use the mapped drive. We are doing a similar thing but our plan is to copy the file...

Were running DS 5.1A on an NT Server. We wish to read a sequential file that is stored on another NT server on our network. Can this be done? If so, how would I do it?

Thanks in advance.

Brad

It works! Thanks a lot Kasia At 15:27 19/08/2002, you wrote: >Depending on how your basic routine is setup you may want to use WRITEV >instead of WRITE. The WRITEV command allows you to write to a specific >column in a hash file. > >Don > >-----Original Message----- >From: Kasia Lewicka [mailto:kata...

Erwan, wolfgang, I omit to say that I load my Hfile in a routine using Open and Write instructions. Im afraid there is no "Update" instruction in Basic Kasia At 14:27 19/08/2002, you wrote: >Hi Kasia, > >make one Hashfile and two Jobs. > >Job 1 writes as you describe and fills ID (which is key) and ...

Depending on how your basic routine is setup you may want to use WRITEV instead of WRITE. The WRITEV command allows you to write to a specific column in a hash file. Don -----Original Message----- From: Kasia Lewicka [mailto:katarzyna.lewicka@cgey.com] Sent: Monday, August 19, 2002 10:11 AM To: data...