DSXchange

True. Use this amazing post by vmcburney to handle partition numbers and number of partitions. Constraint it accordingly.

Shifting of values with two delimiters will not increase the delimiters. SOmething else is happening. For some reason you are getting more delimiters.

What are you trying to do here. Are you trying to see if there are any files present. Then you need to provide

this will tell you all the files. Well not all. Files that start with a dot (.) will not be counted.

Got to the routine itself and try sending an email. Test it from there. See if that hangs as well.

Build the hashed file again. This way it will be refreshed by the most currect records.

TIMESTAMP() converts Internal Date format to Timestamp format (YYYY-MM-DD 00:00:00). You were not providing it internal format. If you really want to use TIMESTAMP() then do this

Ok your confusing me now. What file had correct number of records before and after the conversion? and what is this raw file? you mean one file has unprintable characters and the other one does not?

Read about OCONV with MCP. It does exactly what it says. Changes the unprintable characters to a dot (.) Can you split the records that have more than 127 delimiters after the conversion and examine what changed before and after the conversion. Thats the best advice i can give you from here.

If your on server engine then use a link partitioner to achieve this. If your on PX then your condition should work. for the first link have @INROWNUM < 10000 for second have @INROWNUM >= 10000 and @INROWNUM <20000 and so on.... What error are you getting ? You can also split the file at the os leve...

So according to what i understood, you are supposed to have 127 columns, but when you run OCONV with MCP on the file, you have columns greater than 127 in a few rows. How do you know you are getting columns greater than 127 ? Are you doing a count on the delimiter or the view data on the sequential ...

vsi wrote:Now in order to split this file into separate files i don't know the metadata.

Please help me to solve this issue.

Remember. Datastage is metadata driven. Even file split logic will be metadata driven. If you have no idea about the meta data, how are you going to split the file ?

Depends upon whats the oracle date field. Is it just date or timestamp If its date use this OCONV(ICONV(in.Col,"DMDY[2,2,4]"),"D-YMD[4,2,2]") If its timestamp then use this OCONV(ICONV(in.Col,"DMDY[2,2,4]"),"D-YMD[4,2,2]"):"...

Dont know if that could be done with DS. But here is what i could come up. Contains validation checks only. Validation checks as follows -Check for Zero Length/NULL Email Address -Makes sure Length of email address is greater than 6 as the shortest email address to be found on the net is of length 6...

Hmm. Interesting. Lets think about the logic and how to verifty the validity. But i am sure this is above the requirement of the OP, but a very interesting task. Dont know if its possible though without actually emailing the person, resulting in a lot of non-sense mail to the mailing addresses every...

If you get any key violation, the warning will be created. Thats why you need to explicitly handle it by the method devised, and capture the duplicates in a seperate file. This way you dont send any duplicates. Says who. I did, right there thurmy34: Go to Sequential file stage, go to properties, on...