DSXchange

I did not change the jobs, hence a reference to the new version of the same shared container name. They will not compile without interverntion in every job.

Thanks

Thanks Ray

DSPackagePath it is.

Thanks lstsaur, however I have considdered this and would prefer a dynamic solution that does not require re-configuration between environments. Unfortunately they differ from server to server.

Hi All I am wanting to derive the location of $DSHOME\Engine\bin in a routine on a Windows installation. However it seems that this environment variable $DSHOME (or eqivalent) does not exist, or I just cant find it. It is mkdbfile I need run. I have found the variable "SPackagePath" which ...

I have searched the forum and cannot find a conclusive answer. I am attempting to use the SQL Server bulk load stage, however am getting the DataStage error: "SQL server OLEDB provider authorization failed." The database log contains: "12/06/2007 09:36:26,Logon,Unknown,Login failed fo...

Thanks, that did it.

Too easy to miss the obvious sometimes.

Hi Can anyone tell me why when I follow the steps the the second post of the linked topic, the ID values are visible when performing a "right click, view data" on the source hash stage, but are not present in the sequenctial file output when the job is run. http://www.dsxchange.com/viewtop...

Hi All Does anyone have a slick method of converting second to a time string on the format of h:mm:ss? My source provides the time in seconds since midnight e.g: 21600 converts to 6:00:00 54060 converts to 15:01:00 84600 converts to 23:30:00 I know I can write a custom routine, however I was wonderi...

Thanks guys for the help and confirmation.

Adamksi

I have read many posts regarding exporting jobs using dsexport. However I would also like to export other DS objects, particularly routines. I have tried the /ROUTINE = RoutineName but with no joy. Has anyone any idea how I can export routines as independent dsx files from the command line? Thanks i...

Thanks Ray For FIND/? I get: Z:\DataStage\Projects\DEVELOPMENT1\Scripts>find/? Searches for a text string in a file or files. FIND [/V] [/C] [/N] [/I] [/OFF[LINE]] "string" [[drive:][path]filename[ ...]] /V Displays all lines NOT containing the specified string. /C Displays only the count ...

Thanks Ray

MS Moving slowly.

Hi

When at the UniVerse command line on a Windows installation, how do you shell out to the Windows command line?

SH only works for UNIX.

Thanks in advance

Adamski

There is really no problem since the implementation of Lower and Raise.

However I am frustrated that a dynamic array could not be stored within $UserStatus without further manipulation.

It seems it is not possible to set $UserStatus as a dynamic array: *Set up array TestA<1,1> = '1=' TestA<1,2>= 'One' TestA<2,1>= '2=' TestA<2,2>= 'Two' TestA<3,1>= '3=' TestA<3,2>= 'Three' *Set job user status and log Call DSSetUserStatus(TestA) TestB = DSGetJobInfo(DSJ.ME,DSJ.USERSTATUS) Call DSLog...