DSXchange

snassimr,

no code for this from me, although I think a good search will pick up some. You need to use the BASIC commands "OPEN" to open the hash file, and "READ" to read a record.

Calling DSAttachJob() on your own job will hang for 30 minutes before returning an error, use the mnemonic DSJ.ME to refer to your own job. This has been the cause of "hang" conditions several times in the past.

Roy is correct, I missed that you were calling from a script, and not from an after-job subroutine. Thanks for catching that one Roy!

snassimr, since job parameters cannot be changed within the job they are used in you will need an indirect approach. Write a DataStage job to read the database values and write them to a hash file or sequential file. Then write a short function in Uv/BASIC to read this value and return it to the cal...

dlkkrao, it would help if you could specify the error message you are getting. If your variables ExcludeCount_seq and ExcludeCount contain the Stage and Link names you are looking for then you should be getting a value. If ExcludeCount_seq and ExcludeCount are the actual stage and link names you nee...

As Roy mentioned in your identical post on the Px forum, you can to directly to your scheduler to do things not available from the Director.

(cross-posting is not a good idea here, as most people will check multiple forums)

Kumar,

just declare your sequential file as having one big column and do the EBCDIC to ASCII conversion and write it to a normal sequential file; then start to parse your contents. I've done that before when my file doesn't match the copybook.

It is in your license key, and also visible in the Administrator under license details.

Zac,

Do you have column propagation enabled? Exactly what error are you getting?

How large is your sequential file when the job aborts? Could it be 2Gb and you are hitting a system-level or file-system level limit? Which OS and filesystem are you using?

yaminids, your character set is not necessarily wrong. You might be hitting what are called "gaiji" characters that are not part of the standard mappings; these are sometimes used for archaic characters or corporate logo / specific kanji. What are the offending characters that are not mapped (I don'...

Kumar,

in Px you can do the EBCDIC to ASCII conversion in the sequential file stage, Format->TypeDefault->String or in the "edit row" tab in the columns screen for each field in question.

The server functions ASCII() and EBCDIC() do not exist in Px.

The reason you are having so many issues in creating variables on the fly is because it can't be done. What you could do is to create a variable and then populate that with your name-value pairs. I will assume that your are passing your database DSN, schema, password and user information to your job...

Viswanath, good that it worked; I remember that using the write cache would make jobs finish faster, but that the actual phantom process doing the writing from cache to the disk was actually still running when the job completed; I'll have to check [or wait for someone to tell me] whether or not this...

More information on the deadlock daemon and it's use are found in the documentation, but this is the cut-and-paste from the installation guide: Deadlock Daemon - Windows and UNIX The default state of the daemon is OFF. You must change this to ON in order to use the daemon. To do this, you must chang...