DSXchange

There is a documentation folder installed with your DataStage clients. This contains the DataStage manuals in PDF format. Manuals for each plug-in stage are in the Packages folder on the DataStage server CD, along with the plug-in stages themselves. If you download stage types, there is a separate U...

I did some testing and that worked. I did some more testing and found that you dont even need DSGetParamInfo. You can refer to the parameter directly. JobToBeChecked = "/whdata/JobStatus/" : FileName Thanks, Kenny -----Original Message----- From: Craig Hulett [mailto:Craig_Hulett@rsausa.com] Sent: T...

If you mean you want to retrieve parameters from the current controlling batch, you still use DSGetParamInfo. However, since you dont have a handle, you need to use DSJ.ME instead. From the online help: "JobHandle is the handle for the job as derived from DSAttachJob, or may be DSJ.ME to refer to th...

Could you please remove me from this mailing. Thank you, Lee-Ann ----- Original Message ----- From: "Moderator" To: Sent: Tuesday, February 05, 2002 2:02 AM Subject: MONTHLY POSTING - DataStage Users List - revised > > Cut and paste is a wonderful thing--except at 11:00pm at > night. > > I have corr...

I want to access parameters passed to the Datastage job (Edit/Job Properties/Parameters) in the Job Control. It looks like DSGetParamInfo wont work since I dont have a job handle. Is there a way to do this? Im using 4.0.


Thanks,

Kenny

Make sure to check the actual DB values. It may be that the DataStage view data is only displaying the four decimals. Otherwise be sure to use datatype of "double". -Doug -----Original Message----- From: Muthusamy Karthikeyan [mailto:muthusamy.karthikeyan@db.com] Sent: Tuesday, February 05, 2002 3:4...

Version 2.5.9 is now available from the download location. This should take care of your custom folders problem described above.

Hi World, So, its depend of your Database format time, for example, you get the field using To_Char (in Oracle) with a format that you can convert with Iconv.. (review the DS help to more information), Other way is formatting the date with the next format YYYYMMDD, with this format you can evaluate ...

Hi Muthusamy, Ive encountered the problem that you are running in some month ago with DataStage 4.1 and the only way that Ive found to solve this problem was to use "PRECISION n" command (where n is the number of decimal that you need - max 9), in a basic program. That means that the Field Derivatio...

Hi, We are in process of migrating the jobs from version 3.6.3 to version 5.1. In the process, we had taken the export of the whole project from 3.6.3 development and had imported in to the new version 5.1. In the ORAOCI 8 stage, the decimal fields with 16, 8 ( length 16, scale 8 ) , the value are d...

Cut and paste is a wonderful thing--except at 11:00pm at night. I have corrected the product name in #5. Sorry for the slip of the clipboard. Regards, Clif ================== Posting Guidelines ================== 1) Non-moderated posting This list is not moderated for the posting of messages. That i...

MONTHLY POSTING - DataStage Users List As of 4 February 2002 the DataStage Users discussion list had 526 subscriber addresses. A few of the addresses are to organizations who then redistribute the postings to more than one reader. ================== Posting Guidelines ================== 1) Non-moder...

Hello datastage-users, You will be receiving the monthly posting that includes the list posting policies shortly. Please be sure to read this as several items have been added. Your address being subscribed to either the list or digest indicates your acceptance of everything in that policy statement....

Depending what else you want to do with these date fields, here are a couple of options. 1. Use a TRUNC in the query that reads from Oracle so that you only get the date part. Or 2. compare like this: TimeStampA[1,10] = TimeStampB[1,10] to compare only the date portion -----Original Message----- Fro...

Hi Scott, With Oracle you could use the trunc function in the source query, that will suppress the time part of a time stamp leaving only the date part. Bye. PYB. PYB > -----Message dorigine----- PYB > De : Scott.Burnett@noswa.co.uk [mailto:Scott.Burnett@noswa.co.uk] PYB > Envoye : lundi, 4. fevrier...