DSXchange

Go to Tools-->Option-->Limits
Set the values as required for the individual jobs.

But what is the case for the value of the string in the given warning. Reg Message handler, Right click on the warning messge from the DataStage Directory, and you can handle message by adding the current log. You can Demote to Informational. But it is not always advisable to have the message handle...

Check in TCL whether by executing the command 'LIST.READU EVERY' you your job list. If you able to find in the list, use 'UNLOCK INODE #inodenumber# USER #userno# ALL' If not try to restart the server and try to access. The Log file is seems to be currupted. Try to export and reimport the same file,...

What is the length of the input field?
If it not mentioned, it is considired as string(255). Thus 255 to 114 gives you truncaiton message.

Before executing the DSGetProjectInfo, use DSOpenProject use assign the pointer to point the project your need which in turns is passed as the parameter.

You can use TimestampFromDateTime(). You can give the datea as one input and hardcoded default time as other.

parag - I was just passing on the information to Satheesh, that poster was aware of the fact that the input file is delimeted by '}' and was using the same for this purpose.

Hi Satheesh,

'No there can not be extra spaces as the file is a delimited file and the delimiter is '}' . '
Hope you have you noticed this?

To make a unique sort on the specific columns, you can use
cut -d '}' -f1,2,3 | sort -u > Filename.txt
If 1,2,3 are the key columns.

Authentication issues should not even allow to enter into to designer, but Latha can log in but cannot not open the job. But can have a try with the right user id or dsadm.
Latha - What exactly happens if you try to open the job?

Arnd - Latha able to view the jobs in Designer.
Perhaps she may need a patch for the machine.

Or,
Create a Multiple instance job, and schedule three JobActivity in the JobSequence, each reading the three files sequentially.

Keys in the hash file cannot have duplicates.
Are the records shown are from Hash file?
What is the datatype of the key fields?

Aim at the moon, atleast you can land at the stars....
Dont quench your high speed posts delibrately... Wait untill more player come into picture, and let the forum get obsesed. You ll reach 5K in less than 3 month. Dsxchange should not loose a Premium Poster so soon.

This can also be accomplished by appending the DSJobStartDate and DSJobStarTime in After job subroutine.