DSXchange

Hi, I need to run a script on test server to import jobs from DEV, the issue is ISTOOL utility requires component type as one of its input (pjb for parallel job, sjob for server job etc) Is there a way to connect to DEV project account using dssh remotely and fetch the type of job, for existing jobs...

No records selected

Hi Kim,

The job does have design information as I can see it in the designer.

As usual can't thank enough Ray :) I came across something unusual (atleast to me) Non existent entries in DS_JOBOBJECTS for a job that runs every day in production >SELECT JOBNO FROM DS_JOBS WHERE DS_JOBS.NAME='RDM006dDimDiagnosisCompareTL_td' SQL+; No... 3664 1 records listed. >SELECT EVAL "C...

Hi, Spent quite a time seraching the forum, I want to read entire content of @RECORD from DS_JOBOBJECTS for specific OBJIDNO as one column. Tried the below in Universe stage SELECT DS_JOBS.NAME, CONVERT(@FM,"",@RECORD) AS RECORD FMT '5000L' FROM DS_JOBS, DS_JOBOBJECTS WHERE DS_JOBS.JOBNO =...

Hi, We were facing space issue on project directory when we stumbled on the file ViewData_16443.14287808.tmp under RT_SCnnn folder which was occupying 5+ GB. Looking at the numerals in file name, I dont think this is created by an individual so assuming its internal to datastage (didn't ever see a f...

Hi, I have two Decimal(38,0) values and have to perform a bitxor of numerical values contained in the decimal columns and have the result again in Decimal(38,0) Currently I am breaking the decimal into 3 columns each of bigint type taking 18 digits of string representation (last gets only 2 digits) ...

Hi

I was looking for the format code 'MDO' but couldnt find one instead found 'MD0'. Also the IBM Basic Reference guide does not have the complete list of code except few example ones.

could some one help with what MDO means ?

Thanks

Hi,

I am trying to find detials of various OLEType 's as used in DS_JOBOBJECTS and their descriptions like what "CTrxOutput" means and what "CJobDefn" means so on.

Could anyone let me know where such details could be found.

Thanks
Zulfi

Nothing done on the keys, Dont think the score would report information of sort order preservance across operators.

Hi, I was wondering if sort merge collector is optimised for parallel sorted input. One of the developers wanted a total sorted sequential file and to have so, used a sort stage before the sequential file and left the collector in auto mode. Before flipping the collector to sort merge wanted to know...

Hi, I am reading a sorted sequential file and have a couple of transformers which are using keychange detection functions. I have added a dummy sort over sort keys to mark that the data is sorted but it looks like the transfomer is erasing this information on the output link. This makes sense as a c...

greggknight wrote:Though We are having memory issues with the two new functions
GetSavedInputRecord and SavedInputRecord
Heap Allocation errors.
I am working with IBM on this right now.

Hi,


I am also facing heap error with the above functions, did IBM resolve your issue, was any patch provided ?


Thanks

Hi, The merge stage key has sort order as sub-property and this unlike sort stage doesn't have "Don't Sort (Previously Sorted)" and looking at the osh code it looks like the merge stage is resorting already sorted data. is there any means to force off the sorting on merge stage ? the devel...

ray.wurlod wrote:

Code: Select all

5.  UVread hashedfile keyvalue

Thanks for the reply Ray, Is there a way to fetch all records of select query from dssh by getting rid of "Press any key to continue..."


Thanks