DSXchange

ray.wurlod

What's in the two Char(6) source fields, and what's the required format for loading a Time data type into Teradata?

ray.wurlod

Plural = multi-valued, yes.

ray.wurlod

UPDATE VOC 
SET F2='/u01/csunProjects/epmdvl/CS90_CSW91/hash_file_dir/HASH_DTTM_PS_ITEM_LINE_SF' 
WHERE @ID = 'HASH_DTTM_PS_ITEM_LINE_SF' ;

The terminating semi-colon is required.
Depending on what you saw in LIST.ITEM command, you may also need to update F3.

ray.wurlod

You'll need to build in your own tests. They don't happen automatically.

ray.wurlod

You CAN use a Sequential File stage. It imposes no practical limit on the number of columns. But that was only one suggestion of a few.

And it's perfectly legitimate that a nullable column happens not to contain any null values.

ray.wurlod

Yes. It's weird, but that IS the default behaviour.

ray.wurlod

Does not the documentation say that multiple OCCURS DEPENDING ON are not supported (not multiple OCCURS)?

ray.wurlod

Read the whole line as a single string.
Use Ereplace() function to change the multi-character delimiter to a single-character delimiter, then use Field() functions to parse the individual fields from the string.

ray.wurlod

The FMTS() function will be of even more use. Convert(@VM,",",Fmts(Convert(",",@VM,InLink,TheString),"2R")) The inner Convert() changes commas to value marks. The Fmts() function applies the format specification to each value in the multi-valued field. The outer Convert...

ray.wurlod

Check the VOC entry for HASH_DTTM_PS_ITEM_LINE_SF

Code: Select all

LIST.ITEM VOC 'HASH_DTTM_PS_ITEM_LINE_SF'

I think you will find that the slash is missing from that too.

ray.wurlod

By keeping only printable characters.

But is this really what you want to do? Some of these non-printing characters may be part of your client's valid data.

If you insist, use the "double Convert()" technique.

ray.wurlod

Server or parallel job? The answer will be different.

You posted in the Server forum but marked your job type as parallel.

ray.wurlod

Which book? What is the context? I did not find the term using a search against the Information Center

ray.wurlod

If you look at the match statistics, is there much mention of overflow blocks? You may need to look at a blocking strategy that more finely discriminates potential duplicates, so that the block size is not exceeded. If the records don't appear on any of those links, where DO they appear? These are t...

ray.wurlod

reachmexyz wrote:I am looking to get rid of special characters in the generated file.

Why? Do you have your client's permission to change their data?

DSXchange

Search found 53125 matches

Re: DataStage handle special character A-Hat