DSXchange

Example Config file stated in IBM book. node "n1"{ fastname "s1" pool "" "n1" "s1" "app2" "sort" resource disk "/orch/n1/d1"{} resource disk "/orch/n1/d2" {"bigdata"} resource scratchdisk"/temp&...

Hi,

I was asked to improve "Datastage Transaction Frequency" (Admin Tasks) and I have no clue what that means.

Can anyone help regarding this.

Thanks

split into two paths, use aggregator for one path and the other for details. Finally use funnel stage.

Although I usually prefer to do both unloads from database itself and then combine. Wouldln't recomment aggregator for huge data.

Hi, I am using two jobs to populate surrogate key on a table. Is there a way that I could mention definite range of values using KeyMgtGetNextValueConcurrent i.e. mentioning that Job1 should generate keys 1-1000 and Job2 should generate keys 1001-2000. If overflow, then they start from beginning of ...

Think about it. NULL in any operation (including concatenation) must return NULL. Now re-think what you want to get out of this expression and post that specification. Shouldn't the below code handle the situation, because null is being replaced with empty string. select EVAL "CONVERT(@TM:@VM,...

Use NullToEmpty Function at all three places. However, prefer to do all in stage variables, if not all, atleast the constraint derivation.

I have a select query on uvsh, which concatenates the different fields and replaces any @VM and @TM select EVAL "CONVERT(@TM:@VM,'.', Field1:'-':Field2:'-':Field3) from H_TABLE; This code works fine, when there aren't any nullables in the fields. When any of the fields is null, the output is nu...

EVAL "IF ISNULL(column) THEN '' ELSE column" I have a similar usage in select query involving convert as well. Something like this select EVAL "CONVERT(@TM:@VM,'.', Field1,Field2,Field3) from H_TABLE; If any of the fields is null then the output is null. I applied the above null chec...

chulett wrote:Sorry, for what you've added you're going to have wait for Grognard help.

I'm curious why all the shenanigans, why not just stick with the job(s) you've obviously already built and which are apparently 20x faster?

The idea of not having to create a job everytime a hashed file has to be accessed.

Just you. :wink: Doesn't really surprise me, seeing as how you are basically printing a 'report' to disk. Those numbers in the SETPTR function are line length, page length, top margin, bottom margin, etc. The UniVerse User Reference has all of the gory details. Me, I'd just stick to using a job. I ...

I am trying to do same thing.. i.e dumping the hashed file data A) SETPTR 0,132,2000,0,0,3,BANNER Hashed,BRIEF i) This option is too slow (especially for huge files), almost 20 times slower than a datastage job to unload. ii) The page depth also limits the number of records that can be unloaded. Is ...

Sorry by accessed i meant "readable". Developers should be able to use the routine, but not read the code.

Is there a way we could set a routine (only one routine) from not being accessed by anyone other than dsadm.

I checked with DSLogInfo It issues the command properly /opt/home/xxx/script.sh -H mass -P parameterfile.txt I ran it by copying and pasting it on the terminal. Regarding permissions. I made all directories and sub-directories chmod 777 . But it still gives the same error. When I prefixed the UnixCm...

Here is the code $INCLUDE DSINCLUDE JOBCONTROL.H UnixCmd='' ErrorCode=0 RoutineName = "FunctionTest" pBaseDir=Field(InputArg,"|",1) hSubject=Field(InputArg,"|",2) pFile=Field(InputArg,"|",3) UnixCmd=pBaseDir:"/script.sh " UnixCmd:="-H ":hSu...