DSXchange

This technique, too, (remembering values from previous rows) is taught in DS-ADV ! And you should be able to use neither an intermediate file nor a pipe; just the internal handling of DataStage - at worst an additional Transformer stage. -----Original Message----- From: Don Bradshaw [mailto:donbrads...

We did similar to what Ray suggested. However I wrote to separate output links for each input record type. In this way I could then read the data back in via another link which had the matching Meta-Definition for that actual record type. I wore the overhead of writing to an intermediate file (howev...

Define metadata for the input file as having one column. I presume your column is terminated. Define a stage variable (perhaps called RecordType) in a Transformer stage. Initialize it to anything. As each record is read, update the RecordType stage variable with the first two characters of the input...

Hello, Could someone please advise how I should be tackling the problem below? I wish to read a file that has many record types in it. In fact, I am only interested in two record types. The file is 232 characters long. A record type is identified by 2 characters. Those ones that I am interested in a...

Depending on the number of rows you are talking about you may be better to split the inserts/updates using some sort of cdc. Thereby giving you two links which will contain the number of inserts/updates. Using before and after images in sequential files can help you to do depending on the source ext...

When using OCI ...update then Insert selection, is there a way to have the director log tell you how many were inserts, and how many were updates...rather then just one number of records processed (which is for both) ? Thank You, Patricia Desiano Anheuser-Busch, Inc. MSG - BudNET Data Warehouse 314-...

Hi Giovanni,

Does it work if you log on as DOMAIN rather than just ?

Regards

- Chris Thornton

Hi again, About the problem that Ive to logon to datastage, Ive made some more test. Working with a client installed on DataStage sever, I can connect to the project only if I omit username and password (Im logged to NT with Administrator User). If I try to write the same Administrator UserName and ...

Hi, Try to: - First delete the LDB file thats created by Access in the same directory that MDB file. Try it. - Open the DATABASE in exclusive mode. Try again. - Compact and repare the database (Tools/Utilities). Respect DS, it sounds like problems with permissions. Check the lock record options and ...

Hi All Im accessing a Microsoft Access database via DataStage 4.0.2 running on NT. The DataStage update job was aborted, recompiled and rerun. The job which normally runs in a few minutes is now running for hours and not really doing anything. The job was aborted again. The Access database is now in...

Hi Ken, Thank you for your reply. Yes Ive tried to telnet to the server and it works. And Im using the IP address to connect to the server. Thanks Giovanni Boccia Sales Engineer Direzione Industria e Servizi Datamat - Enabling Your Future ----- Original Message ----- From: To: Sent: Thursday, Septem...

Goto a MS-DOS command prompt. Type in telnet serveripaddress. This is how you reach the box. NT (MS-DOS) is not the same as Unix, you just telnet to the server. If you have a better terminal emulator I suggest you use it. Good luck! -Ken alessio.giordani@inwind.it on 06-Sep-2001 08:38 Please respond...

Doublecheck your hostname. Try a direct IP address xxx.xxx.xx.xxx to find the server. Go to a MS-DOS box and ping the servers IP address. Try to telnet to the servers IP address from the MS-DOS command line. Telnet will try to connect to Universes telnet service. Your problem sounds like you dont ha...

I all, Im working with DataStage 4.0.2 (server component) on Windows 2000 Workstation. Ive windows 2000 telnet service installed on. How can I logon to UniVerse by console? I tried to start "D:ArdentDataStageServerEnginebinuv.exe", but output is not formatted rigthly. Thanks in advance Alessio

Hi all, I ve problem logging in DataStage 4.2 server on NT, by the client. The error is "Failed to connect to host: project: (The connection was refused or RPC daemon is not running (81016))". Ive checked and all services are running (also "Uni RPC service"); I have also stop and start the services,...