DSXchange

At 03:17 PM 3/14/02 +0000, you wrote: >Hello, > >I am trying to use the pre-made routine "DateCurrentDateTime" which >resides in sdk/date. > >The code description says this : > >"In an NLS environment, this routine will not work for most formats, >unless the time/date locale for the job is set to OF...

Hello, I am trying to use the pre-made routine "DateCurrentDateTime" which resides in sdk/date. The code description says this : "In an NLS environment, this routine will not work for most formats, unless the time/date locale for the job is set to OFF." I know I have NLS set to "on" as a default - h...

Boyd I guess the next question would be - what are you trying to do that you feel you need to modify the job sequencer code? Feedback like this will allow us to enhance the product so that it can be even more useful to you. There are also numerous different ways to do things so perhaps someone on th...

Primarily functional. MQ Client cannot participate in global units of work, and requires a syncronous connection to the MQ Server. Ernie -----Original Message----- From: Craig Bennett [mailto:craig@cross.net.au] Sent: Wednesday, March 13, 2002 5:49 PM To: datastage-users@oliver.com Subject: RE: RE: ...

you could possibnly try something like this....... select {hashfilename} with (dateA >= beginrange and dateA = BeginRange and dateB > ie. I want to find all records in the hash file where date x in the primary input falls between date a and date b in the hash file. > The only alternative I have now ...

no you cannot modify the generated basic from a job sequence (unless you cut and pasted it to a control tab). This is done intentionally since it would be too difficult to regenerate modified code back into a gui representation of the code within the sequencer.. Andrew Webb Principal Presales Consul...

Hi all, this is a request to all Ascential people. I remember that it was an URL where all DS users was able to find documentation about Datastage and Datastage Plug-in (m) Now i cant find a similar web site. Where DS users can find Datastage and Plug-in documentation??? Moreover, where i can find t...

Hi,

I am using DataStage5.1 to create job sequencer. After I drag and drop in the GUI, it will generate some BASIC code. The issue is I cannot modify those codes. Is there anyway I can modify it?

TIA,
Boyd

Brad, why cant you just do a Call DSExecute("UNIX", UNIXcmd, ScreenOutput, ReturnCode) from a batch job after running your server job? You construct your UNIX based command (like a shell script that starts sqlplus and executes a passed command) and put that in your UNIXcmd variable. The screen outpu...

Hi, In DataStage 4.2, Oracle 8 OCI stage version 3.0, OCI 8.1.6, you have two options, Before SQL, and After SQL. This feature can be used to run stored procedures after the OCI stage finishes loading data. The call can be to a stored procedure defined in a package or otherwise. If there are no para...

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Really? What are the differences? I implemented a GCI interface to MQ for UniVerse and the only change I made between running on a server and on a client was to link to a different library during the compile. Can you tell me (for interest) what the diffe...

I all,

does anyone have experiences or documentation about "Ascential EMC InfoMover Plug-in for DataStage"?

Regards,

Alessio

I would think you could just read it in as a string and use ICONV along with the "J" and "Y" modifiers to get it into an internal format, and then do the normal OCONV back out into your Oracle format... typically all in one nested statement. Better yet, write a routine to do this so you can include ...

Hi there, wondering if anyone can help. I have a julian date field coming in from a file which I need to convert to oracle format (DD-MON-YYYY) for upload. Is the Internal System format for dates in datastage julian? I cant seem to find out what the datastage date type is called. I would ideally lik...

You can execute a procedure using the custom SQL option in an OCI = stage. Due to syntax requirements of the stage, you must pass at least one parameter, so the procedure must accept one even if it isnt needed. The call needs to be within a begin...end block and written on a single line. For example: