DSXchange

Hmm, something else I learnt today. Thanks for confirming that. I will have to test it out some time.

I am not sure if a any positive number other than 1 would be considered as TRUE as only 1 translates to TRUE. Test it out, let us know

A slight correction jhmckeever, if I may:

in the constraint to filter records that contain the literal '0X0'

'034' is ascii code for double quotes. Thats how it worked

I never said &PH& and &COMO& folders are involved. I merely mentioned the names of these folders as they are present in the Project directory as well. Their mention was merely for directory mark (from land mark )

If you source is a flat file, ISNULL() might not work. Check for the Len() after trimming the field. If its 0, assume its null.

WHats the size of the varchar field defined at the database level? What error messages do you get? Need more info.

Its better to 'shout out' as a new post so that 8.0 folks can see post headings and respond. IMHO.

Please dont do that. Please provide complete information of your design that your testing on. Do not give one design and test our suggestions on another design. My basic point in asking the trigger was, if its unconditional, no matter what, all jobs will run and all conditions are being handled (Unc...

Inside the job activity, you have a trigger expression to specify under what condition to run the next job. Whats specified there?

I have tried it as well. No issues at my end.

Because the display is set like that. You can set the format to anything in TOAD.

What is the trigger expression that you have given?

O okie. Cool.

If its just a few records, build a server job, load a hashed file and then re-load it into a flat file. Records are randomly distributed in a hashed file.