DSXchange

I am in a project where they need to setup a baseline The strategy is to read the DtaStage categories and output category/Job Identifier to use to do single job export commands to GIT(like SVN...release management) We are on DataStge 7.5 .... the repository is not in DB2 tables ...its in files(uv) w...

Hi there,I am connecting to SQL Server tables thru ODBC stages when I import the DDL's I noted that data types 'date time' come in as data type '93' - which is not a valid data type When I link the connector stages to a join stage - and I attempt to view the input columns - the page is grey with no ...

I have created two generic sequences and made them multi Instance These two generic sequences - named 001 and 002 - work this way The Master Sequence calls 001 which loops and calls 002 --- 002 runs 10 Multi instance jobs to run in parallel If one Multi Instance seq fails Then : does this impact the...

Hi there, I am attempting to Use a server job in EE to load BLOB from PDF file = takes file as one row - fine - but am unable to convert it with server stages and fuctions to a raw binary format - am now looking at encode in EE - but I have seen comments on dsxchange where folder works - if so how??...

Hi there, I am attempting to Use a server job in EE to load BLOB from PDF file = takes file as one row - fine - but am unable to convert it with server stages and fuctions to a raw binary format - am now looking at encode in EE - but I have seen comments on dsxchange where folder works - if so how??...

Hi there, I a attempting to use Encode Stage to load a PDF file to a MYSQL BLOB - in the stage I have coded command line gzip files/pf_shdw_images/bp00000623_pj07069374_id00289727_id00216865.pdf Inpot column is IMAGE largevarbinary length of 2147483647 same on the output column it fails in load to o...

Line marker button now only show auto or nothing
but when I hover the mouse over the job in the repository listing on left side of Designer screen I can see the line markers - is this a bug with Fix Pack 8.5? any one experioenced the same?

YUM, Did you ever find a solution for this? If so, can you please let me know? I am facing the same exact problem. I can do this in a shell script but I am concerned about losing the parallelism. I appreciate your help. Yep the solution was to 'nest' a sub sequence - ie branch to the same sub seque...

Ray - what about a sub sequence - that gets passed the current Nested Condition triggers - to run a Nest_Condition within the Sub sequence - when any or all jobs finish in the sub Sequence it returns to the calling Sequence - no routine necessary - will test and advise results

Cool Thanks Ray - I was thinking User Varibles - but this is much simplier - do you have examples of this type of coding? - I am guessing Innovocation ID and Job Status - as you said - check on the three possible streams after exiting the Any Sequencer - with a wait type loop on those jobs running

Hi there, I am testing a DataStage Sequence - it has branching in it - I am using a Nested Condition - that runs 3 possible out links - sometimes only one will run, sometimes 2, sometimes all 3 - depending on dates and other parameters passed into the Nested Condition my problem is that it runs fine...

I am updating a set of SEQ's with 7 job steps in ackh Whem I update just one parm of say 6 for each job in the SEQ then OK out and save I can usually get up to job step 2 or 3 before DataStage cloese down - this makes the updating of parms very slow - If I try to update all the parms and triggers fo...

Hi there, During the Load to our Involved Party(IP) table we compare incoming fields to what is on the IP table One field we compare is a Varchar 20 field - we compare that to the incomming varchar 20 field .. if different then update. I have the incomming field set to 000000 and the IP value set to...

Hi there, We have a master sequence that aborts when a child datastage job gives warnings. This is what we want but the master sequence is no longer restartable - it must be rerun. Reason is our master sequence is only restartable if a child sequence aborts or a child datastage job aborts. In this c...

Hi there, My team has setup restartability thru seq'ers running jobs but have hit a problem ... the initial job in the master control seq'er creates the Batch_id for subsequent seq'ers - we passed down the batch_id as the user status from the create batch job - we had problems with create batch as i...