DSXchange

Is there a way you could employ the use of surrogate keys to the rows in the table, or even add row numbers? That way you could specify where the next select can start. Just a thought. -----Original Message----- From: Mark Steen [mailto:mark.steen@damanconsulting.com] Sent: 19 September 2002 05:52 T...

obviously, but the point is that the columns are not numeric and Im having a difficult time how to identify a simple scheme that can be parameterized. the data looks like 002938 Z342356 123847 13451345 and the fields are defined as a char(6) and a char(9) 2 indexes - on on both fields and one on the...

Hi, You can split a file based on a key using the XML stage. For a full explanation of this search m looking for "Splitting files based on a key field" You can then just set up a couple of stage variables. One hold the filename "key" and the second to increment for each input row and reset at 1000 a...

Just use job parameters in the WHERE clause: WHERE keyfield BETWEEN #StartValue# AND #EndValue# If keyfield is not numeric (which "concatenation" suggests), simply quote them: WHERE keyfield BETWEEN #StartValue# AND #EndValue# -----Original Message----- From: Mark Steen [mailto:mark.steen@damanconsu...

Create one job A to do what you want with n lines of the file where n is the number of rows you want to process at a time. This job will add a header, process n lines and then write a trailer. Add a a constraint to only process rows m to m + n - 1 where m is a multiple of n where the multiple will b...

I want to split a large job into pieces to run in parallel. My source is a DB2 database The key is a concatenation of 2 character fields (mostly, but not all numeric values) My problem: how to write a simple generic where clause to return a subset of the values thats can be repeated. if the data wer...

Hi Jeremy, it is no easy problem you have. In my mind I get two approaches how I would solve the problem. Way 1: I would code it in Jobpropeties under code. Openseq and Writeseq and a counter, perhaps 10 lines code at all. If you dont know how to, let me know and I give you the details. Way 2: With ...

I have a requirement to generate files containing details of transactions. Each of these files should contain no more than 1000 records with a header and trailer record. The number of files created will depend on the number of transactions. For example if there are 2500 transactions there will be tw...

The /O flag is the equivalent of the "Omit" checkbox on the client Attach dialog that you see when you login to DataStage. You can either specify "/U=username /P=password", or "/O=1". The former case connects via TCP/IP; the latter case means connection is made via LAN Manager so your current Window...

This is a topic for an orphaned message.

Good question, Wolfgang. All I did was capture the output from the command. I do seem to recall, however, that /O does mean "omit read-only items", corresponding with the check box in the Manager clients Export dialog. I guess it calls for someone to perform a test. Something for ones "copious free ...

Hi Ray, Does the [/O]-flag in import and export not mean overwrite? Export: overwrite if *.dsx-file already exists Import: overwrite if the object (Job, Routine, Tabledef....) already exists Wolfgang > -----Original Message----- > From: Wurlod, Ray (BSG) [mailto:Ray.Wurlod@riotinto.com] > Sent: Wedn...

As with many DataStage executables, entering the command name alone will invoke a usage summary. usage: dscmdexport [/H][/U][/P][/O] project filepath [/V] /H Host name. /U User name. /P Password. /O Omit flag project Specifies the project name. filepath Specifies the export file name. /V Verbose. De...

Hi, Importing and Exporting files is a client task, so you cant run it from the server. However, for those running on Windows, you have the luxury of installing the client on the server. You can run DSImport.exe and DSExport.exe from the command line but these have the unfortunate habit of pooping u...

depends on the reason. the short answer is yes, the longer answer depends on what you want to do with the .dsx im guessing its for backup... there should be a dsexport utility in the datastage directory somewhere. --mark At 11:02 AM 9/17/2002 +0100, you wrote: >I have been asked by our support peopl...