DSXchange

Stacy Scoggins Principal Engineer, Data Warehouse 214.550.7408 stacy.scoggins@kinkos.com ***************************************************************** The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by any...

Hi Denzil, The monitoring feature has been designed to keep to a minimum the impact of monitoring a running Server job. Assuming you have a separate client-server system (so we can ignore CPU used by monitor client GUI itself), you have the small overhead of an extra connection to your server. The m...

Hi all Just as a matter of interest - when you monitor a job, how much resources are you taking away from the job to run faster? Is it not worth noting, or is monitoring the job significantly using potential job running resources? in other words - can monitoring a job slow the job down? Denzil

Woo hoo indeed !! Thanks Ray, will give it the routine a try. -----Original Message----- From: Ray Wurlod [mailto:rayw@mindless.com] Sent: 04 October 2002 10:14 To: datastage-users@oliver.com Subject: RE: Julian Dates I had meant to add that you *could* do it as an in-line expression or Transform, b...

I had meant to add that you *could* do it as an in-line expression or Transform, but an ugly one. Oconv(Iconv(TheDate[1,Len(TheDate)-3]+1900:"/":TheDate[3],"D/YJ"),"D-YMD[4,2,2]") Woo hoo! ----- Original Message ----- From: "Ray Wurlod" Date: Fri, 04 Oct 2002 18:06:08 +1000 To: datastage-users@olive...

101255 is not what I understand by a Julian date. What I understand by a Julian date is something made up of a clear year and day component. Now that I can see your data, your transformation becomes easier to put together; if the year component is >= 100, you need to adapt it. How about the followin...

Hi Ray, the Julian date is in the format YJ, no delimiters. I get Julian dates in the format 97365, 101255, 98031, 98001 etc. I have tried changing the OConv statement to DYJ, no joy. How does one check the setting of the CENTURYPIVOT tuneable? -----Original Message----- From: Ray Wurlod [mailto:ray...

Does your Julian date have a separator of any kind, and is it in YJ or JY order? It may help to be more specific in telling DataStage these things. For example OConv(IConv(JulianDate,"D/YJ"),"D/YMD[4,2,2]"). DataStage also prefers a separator (though can work without). You might also check the setti...

The following is a code snippet from a DataStage Job Controller. As mentioned in a variety of messages last week, you are not allowed to set parameters from within the Job. * * Get the Job Handle ID for the requested Job which is to be executed. * If we are not able to execute the Job, see if we can...

You cant - the parameters have to be set bejore the job starts to run. What Id suggest you do is create a controlling batch for the job. This batch would do the reading from your initialization file and then be responsible for setting the parameters and launching the job. Or the batch itself could s...

Im trying to modify job parameters from within the job itself using the following code: err$code = DSSetParam(DSJ.ME, ParmName1, ParmValue1) and I get the following error: Controller problem: Error calling DSSetParam(dbid), code=-1 [Invalid JobHandle] I have tried putting this is a before-job routin...

Hi Guys I have to convert a julian date to a normal yyyy/mm/dd date format. I have used OConv(IConv(JulianDate,"DJ"),"D/YMD[4,2,2]") to do the conversion. It works fine except for years 2000 onwards. Does anyone have any ideas on how to do this? Thanks This message contains information intended sole...

More details : In your Oci/Odbc stages enclose your parameters names (dsn, user, ...) in #, add them also to the Job Parameters list. The values for parameters will be set at job run. Kasia >Mailing-List: contact datastage-users-help@oliver.com; run by ezmlm >X-No-Archive: yes >List-Post: >List-Help...

This is a topic for an orphaned message.

Simple - use job parameters for everything that can change when moving the jobs between environments. At a minimum, we include the Oracle DNS name / TNS entry, userid and password. -craig Chris Roberts 10/02/2002 07:42 AM Please respond to datastage-users To: cc: Subject: Test Environment I am tryin...