DSXchange

yaminids wrote:I am calling the routine from the constraints section in the transformer.

This is something that can be done? Never occurred to me to even try something like that. From inside the Constraints section?

ray.wurlod wrote:Because COBOL compilers on UNIX are very rare beasts indeed!

COBOL compilers on Windows are even rarer.

Not really all that rare. Microfocus has been doing COBOL on tons of platforms for what... decades now?

What does that have to do with the question you asked?

Still need help with this? Look at some of the Date routines supplied in the 'sdk' section - there is alot of code you can 'borrow' from there. You should be able to handle d/m/yyyy and dd/mm/yyyy with no problem with one conversion. You need to do something similar for the time portion as well... s...

With the number of posts made to this site over the years most questions have already been answered. Many times. Search is your friend!

For example - this thread.

Run your second link to an aggregator first and then to the update. Send a numeric field set to 1 for every row that goes down the first link or a 0 for any rows that don't... either that or have them use the same constraint. Then just do a 'sum' in the aggregator. If there are no constraints involv...

Search for dsjob in this forum only and narrow your search by Author kcbland - that should help. Some.

Yah, it's a big shiny lightbulb for all of us at some point. Possibly stating the obvious, but keep this in mind as you branch out and expand your Routine creation skills as there are other header files that come into play as you build more 'functional' things.

I have a Transformer that outputs about a dozen fields, but those fields are only a subset of the fields that I want to output. If I clear out the metadata from the sequential file at the end of the link, and load in the actual file definition, then all the derivations will disappear (the derivatio...

Hmmm... I've always done all of my installs and upgrades as root over the years and this is a new one on me. I guess something permissions-wise is the problem. What permissions are on $DSHOME? Any 'sticky-bits' or the (what is it called?) SUID set? And out of curiousity, what operating system? Check...

You need to add the following code so that the header file with the definitions of those Job Control functions gets compiled in as well:

Your target stage in the job should be an OCI stage. Your target field should be declared as a type of Timestamp in the OCI stage. Then you need to use Iconv/Oconv to get it in the format that the stage is expecting: YYYY-MM-DD HH24:MI:SS People typically build routines to automate this so they can ...

Strange. The parameter marker the ODBC stage uses in not numbered - Oracle, yes but not ODBC. It uses a simple question mark, so you would need to change all references to colon-anything to '?' - and then ensure they are listed in the same order as your columns are defined in the stage.

You can't move this thread - Ray has asked The Powers That Be to do that for us. For now, just take this conversation over to the proper forum if you have any other questions!

Just include it after a 'dot' at the end of the jobname. So you would run 'jobname.invocationid' from the command line.