DSXchange

I recently had to go through the same type of issues with dates, the format needs to be explicit in PX - a %yyyy-%mm-%dd format will error on a "2005-1-1" date! There is no direct and easy workaround for this in PX; you will need to cater for these types of formats yourself. Or think about using a s...

Poorna
this is best taken up directly with your support provider; they know what the patch .dll is supposed to repair and will be able to provide better assistance than what you might get here - at the moment it just looks like a bad library - what happens when you revert to the original library?

Yattin,

there is a builtin routine at sdk\DataType\DataTypePicComp3 which will convert a Comp-3 field into a numeric displayable one.

Sunil - a CFF stage will do this correctly, I am not sure what your issue is, but it will take a USAGE COMP-3 and convert it.

No problem with the question; just tell me what the budget is for solving it and I'll get an answer for you. To the original question I need a routine to validate a hash file. The "hash" has been addressed, the "need" has been touched upon so I think I should ask if it's really a "routine" or if a f...

From an application's point of view, a file on an NFS-mounted drive looks as if it were "local" to the machine. So you can access it without problems; I don't know why you want to have the machine name in the filename, but you can choose whatever approach you like.

Kumar,

thanks for the post and answer, but this is a different issue entirely; there is no place to enter the userid and password when doing a repartition to DB/2 in a transform stage. I will wait until Monday and then try Vincent's suggestions {once I find the property list he mentioned}.

Indrani, I am unable to tell you if you have the disk mounted - you need to check the filesystems to see if you can find the disk or talk to your system administrator. DataStage has a FTP stage which can read or write sequential files on machines accessible via FTP and do so line-by-line instead of ...

How about using NFS and doing a remote mount of the device?

My fault with the original formula, it should be

Ragu, this question has been posed many times, please try using the search functionality next time. Hashed files use 32 bit pointers, thus they have a limit of around 2Gb unless they are created with the 64BIT option, in which case their limit is larger than the storage capacity of any machine we ar...

Hello Vincent,

which "properties" tab are you referring to - I can't find it

Hmmm, your routine seems to do what the suggested code that I wrote does in more steps, plus it will only work if the elapsed time is never more than 24 hours - because you aren't checking the date but just the time values. You can divide the seconds by 60 to get minutes and also do an INT() to trun...

Hello its_me48, even though this subject has been handled several times before, the way you posted the question was clearer than others, so I figure if an answer gets posted here it will be found by others using the "search" mechanism Assuming the end date/time is always in the correct format and us...

Hello Luciana, you seem to have picked up on a long-dead thread (from June) on your response. Also, I think that the solution you proposed doesn't address the original problem. The 60-second value is hardcoded and the solutions were to make the job actually start quicker on a heavily loaded system. ...

Even though there is no solution directly in sight there are now a couple of facts available: - table is not broken - View Data is working the same as the job - the sorting shows that the whole table is being used & sorted. - the job is not stopping due to an error not shown in View Data (since ...