DSXchange

Hi, not sure if this has been covered before but have an export of a 7.5 project that have imported into v8 Some of the jobs are ReadOnly and want to make them editable , however the two ways I have done this before are editing the DSX file or updating DS_JOBS set READONLY="NRO" kind of st...

Cool - that worked a treat - I knew I could do something clever but it was a long day

I actually ended up writing an Awk program to do it - but this is a lot more suitable as I prefer to keep the logic visible as it were.

Many thanks ameyvidya

Ed

I guess I do -could set the max to some thing big (e.g. 50) but didnt want the faff of it - wanted a more generic solution

hi, I Have an input file containing a single pipe-delimited column and I want to be able to convert the pipe delimited 'subcolumns' into 'real' columns then pivot on them - the catch is I dont know before hand how many of the subcolumns there are e.g. source Key DelimCol A 1|4|5 B 7|8 C 9 target A 1...

sussed it - it WAS just a case of hard coding the condition - just seems for some reason that the menu option borked

thanks for input guys

evening ray , yes there are input columns being fed into the lookup stage , this is a design rather than a runtime issue - just cant select input columns as an option from the dropdown Actually sorted the functional issue with what is commonly known in UK as 'fudge' but in my never-ending quest for ...

Hi, I am probably being dense (dont all shout at once) but have a simple job read Seqfile A do lookup (lookup based on single key value, lookup data fed into lookup stage from Sequential file B) and wanted to do the lookup ONLY if A.FIELD <> something - but when building the expression the input col...

further to the above - if your hash file IS the culprit - u may well need to tune it as the default settings in terms of modulus , seperation , type (i.e. wholly numeric key , numeric variance to right etc) are often not best suited to your data. I good place to start is the hashfile calculator (sho...

one (possibly useless) remark on using enterprise stage for TeraData - we found that it seems to do a count(*) before and after the actual load (which as already mentioned does a fastload into a staging table - then insert from subselect). If there are more than 2Billion records in the target table ...

I have a simple sequence that runs and it uses the project default for $APT_ORCHHOME. The sequence failed but on the re-run of the sequence, the value returned in the log for $APT_ORCHHOME is now the default set at the Sequence Job properties level. It is very easy to remedy this but I do not unders...

this is caused by a hardwired timeout limit of 60 seconds in which the job has to kick in - and this can be missed if lots of jobs kick in at the same time, the main problem is each job has to open universe files for logs, config , status etc - this can be tweaked via uvconfig - but only two cetain ...

another way this can happen is if one of your keys contains nulls - ive seen this before and it produces oodles of output

few issues here - a sparse lookup in PX means that each lookup will go to the database (a non-sparse lookup unloads the data into a dataset - which makes the lookups a lot quicker). So sparse lookups are generally slower also if you havent got a primary key or index on the table then the whole 290Mi...

u need to add the optional parameter called client instance name (this should be the name of the 32bit client on your app server)

the name and user name parms then appear

im a bit rusty on this but believe the problem is that you are getting a Unique Constrain violation if you look at the last lin es 0025 .if &SYSUVCNT then; **** 00:38:04 UTY2402 Previous statement modified to: 0026 .if 1 then; 0027 .logoff 20; This I beleive means that it has found >0 records in...