DSXchange

Whenever I see that happen, it is usually a filepath issue. Are you sure the path is set correctly in flat file stage? By default the stage will keep the link name and write the file to the project directory.

/usr/opt/uv/DataStage/projectname/linkname

Is it a dynamic file? If so, check your dsconfig file and see what the T30FILE param is set to, If it is set to its default of 200, you may just have too many dynamic files open within your project at that certain time.

Ollie

Our S.E. here in Kansas City seems to have quite a bit of interaction with the higher ups at Ascential. We have also seen Jim Welch now and then and he is always open to new ideas and thoughts each time we have met with him.

Oliver Nielsen

Here is a little Korn Shell script that I use to delete a db2 table quickly. I call it load_blank.ksh if [ $# -ne 3 ] then print "You must enter the instance and database and table name" exit fi INSTANCE=$1 DATABASE=$2 TABLE=$3 db2 -v "connect to $DATABASE"; db2 -v "load fro...