DSXchange

No, there's no function but that 'cat' should work fine. Cat both columns and then use 'cut' in the script to get just one of them.

Obviously, they want or need something quoted or this conversation would have been over quite some time ago. :wink: Yeah chulett. We want some of the columns needs to be quoted and the rest needn't. :? You *do* realize that in all of this exchange that you've never given us specific examples of the...

You can't trim a character field, they would need to be Varchars for that to work.

You are talking about CRC32, not BASIC transformers in Parallel jobs, yes? I seem to recall some of the odd issues you had with it...

Change the datatype from Date to Timestamp, then use a TO_CHAR() in your select query with the appropriate mask: "DD-MM-YYYY HH24:MI:SS".

No, they are saying that the entire thing can be seen when they View the log using the Director but a command line "-logdetail" call only pulls out an abbreviated amount, so that's all DataStage.

I'm just not aware on any limitation of what that particular dsjob option may or may not have.

Data type of the field in the job? Generated or custom sql?

What are the data types in your job for the fields in question?

Obviously, they want or need something quoted or this conversation would have been over quite some time ago.

I think you actually have a resolution rather than a workaround, but that's just me.

It's something you are going to need to experiment with to find the 'sweet spot' for your data in your job on your hardware and your configuration. Suggest you do this in a methodical manner and document as you go so you know what works and what doesn't.

Write your own as a BuildOp, plenty of C/C++ code out there for the taking, I would think.

Curious what this has to do with the topic at hand... or are you just delivering random nuggets as early Christmas presents?

veera24 wrote:I dont want the quotes for string and as well as timestamp column.

I have no idea what you want or don't want here.

What is being quoted right now that you don't want quoted and why do they bother you? All fields can be quoted without issue or causing anyone any problems, hence the question.

I honestly have no idea. Seems like the kind of question you'd need to ask a vendor to get the answer for, however.