DSXchange

Sure, you can 'add days' as long as you don't care about leap years: 100 years in days is just + (100 * 365). You'd have to get more sophiticated to handle this properly. From what I recall, Ken Bland has routines to do this on his website and may have posted them here as well. Ray Wurlod has Server...

Done properly, it should solve your 'problem'. Try executing this manually before executing dsjob and see if you still have the problem:

Actually, I believe they do. So, yes - if you want to transfer the old values to the new server, copy those files over.

That was my assumption as well of the meaning behind the query, but wanted the interloper to spell it out.

You don't need to do the subtraction in the SQL, although I'm sure that can be done. The routines you can find here would allow you to subtract a month from the parameter before it is passed to the job.

Ask your DBA how to do that in DB2 SQL.

The process of updating the DSParams file *is* automated and not something you generally need to worry about. What do you mean by your statement? Can you be more specific?

You did not make the changes I suggested to the SHLIB_PATH lines, curious why not? However, that certainly isn't causing your issue. I have no idea why it is looking for anything in '/ardent/uv' and I'd be surprised if that directory actually exists. I'm not somewhere where I can check anything on m...

Where do i need to change it? My $ORACLE_HOME is at "/oracle/product/10.1.0/network/admin" That isn't your $ORACLE_HOME. Insert this line into your dsenv file, just above the #LANG section is as good as any: ORACLE_HOME=/oracle/product/10.1.0; export ORACLE_HOME You have two SHLIB_PATH assignment s...

Ack! Too true.

Do an Exact Search of the forums for "Action=17", several have resolutions posted - none of them helped you? To help cut down on wasted time, which solutions did not work for you? Open a case with your official Support provider if it's 'urgent' rather than wait 'quite some time'. Do so now as a cont...

That's certainly one way and a useful pair of jobs to have. You could also simply copy the hashed file - after executing the routine once in the new project, so that the account (VOC) information is properly setup.

I suspect you may actually mean 'in DS EE' or PX. And what do you mean by 'functions'? If 'function' means stage, you'll find is there is no 'Join' stage in Server and that the 'Merge' stage is used to merge two flat files, a completely different operation from what the like named stage in EE perfor...

I tried searching for something silly - 'subtract month' - and easily found what you were looking for. You may still need to branch out from there as your definition of what 'one month' is can change the answer.

Yes, derivations within a link 'operate top down in their grid'. However, you might as well think of them as simultaneous as you can't use the result of one in another. That's what stage variables are for. As noted in your other post, links fire in their link order and their derivations are only eva...

Also check the Command Line Interface chapter of the Server Job Developer's Guide pdf.