DSXchange

I guess it would be the same as any other table for food ... you put the hash on the table and serve it from there

If you mean a hashed file, that is a server-specific topic, and you are posting in the Parallel forum.

So when's the interview???

Just for fun, try specifying the file path instead of a parameter and see what happens. I've tried it using #PARAMNAME#test*.txt, where the PARAMNAME parameter is set as type pathname, and as a regular path, like D:\MyPath\ - works both ways. Is it possible you've defined your #PATHTOFILE# parameter...

Well, it's been awhile ... we've had 'fun' working with IBM Support to try and solve this. We could actually run a sample OSH file at the command line and connect to a Lotus Notes file, but not through the GUI. Finally, we are now able to import metadata from a Lotus Notes 'database' (i.e. a .nsf fi...

I guess the first thought is - why is the file size so huge? Any way to pare down the size? Other than that, a .csv file is just text, and zipping it should drastically reduce the size of it. I can't see it being an issue.

Where to start???

First, your RAM is woefully inadequate, and I'd certainly want more than 75GB on a disk. More importantly, though, DataStage 8.1 Server needs Windows Server 2003 ... it isn't supported on Windows XP.

When's the interview????

Try RTFM.

No need for an ENV variable. Just go to the Limits tab and check 'No Limit' under warnings.

When's the interview??

ray.wurlod wrote:VS2008 is supported for DataStage version 8.5.

You still have not advised the settings of the four project environment variables in the Compiler folder, as requested. ...

Which is why I mentioned what I did about VS2008 not being supported - he said he was on DataStage 8.0 ...

At least up to 8.1, VS 2008 wasn't supported by IBM - only 2003 and 2005.

Make sure in your Sequential File stage that you are setting a null value. Go to the Format Tab, and then Field Defaults. You can then specify the null value. Of course, make sure that nullable fields are also set as being nullable.

Forgot about the -wait duh - not enough coffee yet ... though my Kornshell remarks stay the same ...

Maybe you should check your Kornshell reference for proper syntax ... this is a DataStage forum, not a Kornshell forum :roll: Have you tried something like (not tested) .... #!/bin/ksh typeset -i i=0 while [[ $i <= 100 ]]; do dsjob command & wait insert error checking routine here ((i+=1)) done

Look at my post ... after the dsjob command you need an ampersand (i.e. &) to put the job into the background ... then the wait command should work.

If you are using KornShell, you can wait for the job to finish by using the wait command.
For a sequence, set the sequence as adding checkpoints to be restartable, and in your Job Activity set the Execution Action to Reset if Required, Then Run.