DSXchange

Hello, I have a typical problem. My target is a Teradata Table. I have to Update the Existing records for sertain field and Insert New record for the Corresponding updated record. In Teradata for Update and Insert link if I put Transaction size more than 1 then the Table gets locked. So the only opt...

Exactly. Somehow my access to the required project directory was removed due to some confusion and that created all this problem Thanks a lot for the suggestion "Nothing" is not the correct answer. Either you've run out of disk space on your client PC or you don't have write permission whe...

No nothing was changed. Only due to a wrong parameter value the Sequencer got aborted. So after changing the parameter value I had to recompile again. But I used compile this Sequencer till date and this sequencer used to run everyday. But all of a sudden I got this problem when I tried to compile t...

But I used compile this Sequencer till date and this sequencer used to run everyday. But all of a sudden I got this problem when I tried to compile this. You need write access to your c:\Program Files\Ascential\DataStage directory (or whatever equivelent directory your DataStage Client is installed ...

Hello, While compiling a Job Sequencer, I am getting the below mentioned error. <JobSeqGenError> <Code>2017</Code> <Desc>XML parser error on input line 0: source='', reason='The system cannot locate the resource specified. '</Desc> <LineNum>0</LineNum> <Line></Line> <Ref></Ref> <Version>7.5.1.18</Ve...

Thank You Sir. This seems to be cool. Thanks Ton. I will try to implement it. In case of any issue I will again get back to you:). thanks a lot again Drop a Sequence object on the canvas and set it to 'Any'. Drag a new (second) link from each of your Job Activity stages to the Sequence. Change the t...

Chulett,First of all thanks for your reply. But As I am very new to Sequencer. I am unable to figure out as to how to funnel any failed jobs to a Routine Activity stage that calls one of the Utility routines like UtilityWarnToLog. Actually, this is a very typical problem people run into when first h...

Thanks for the prompt response. But I am new to Sequenser and I do not know how to have Multiple Triggers for a Singel Job Sequencer. Could you please be more elaborate on how to achieve this. Hello, I am facing a typical problem. I have never faced this before. I have a Sequencer which intern has m...

Hello, I am facing a typical problem. I have never faced this before. I have a Sequencer which intern has multiple sequensers inside it with proper dependencies. Let's say My parent Sequenser is PS and the child sequencers embeded in it are S1, S2, S3, S4, S5. Now the dependency is as below: S1->S2-...

Thanks everyone. It works perfect with INDEX(). Thanks a lot for the prompt help. In this case all the States are 2 digits and don't contain substrings of each other so the quick INDEX() will work well. If you were looking up a country list which might have ...USA,UK,UKMENISTAN... {doesn't exist, bu...

Thanks Kenneth. it works. But lets say rather than getting the Character Number of the first occurance I need only 0 and 1. 1 for Found and 0 for not found. Is there any shortcut way to this. Put all of your state codes into a comma separated string, then just use the INDEX BASIC function if you can...

Hello, In a routine I want to validate if the code is one of the valid US State codes . If yes then return 1 else return 0. I have used the below mentioned routine code to get the result. But I do not think this is an efficient and compact code. Can some one help on this. Ans =' ' If Arg1 = 'AR' or ...

Hello, I have a file that is Comme Separated file. But problem is that in value of the field itself I am getting "Comma" in between. e.g. "1965","LONDON","PETE, QUARTERS","TRACKSAVE","1234" For the Third field how do i get rid of the "...

Thanks Craig. I got the points. Thanks a Ton. Keep in mind the fact that 0 is the same as 'false' or equivalent to the @FALSE system variable while 1 (actually any non-zero value) is 'true' or equivalent to the @TRUE system variable. Check the online help for reject row handling as it goes through a...

thanks. Let me be more specific. I have one input link Say Input. I have two Output links say Output1 & Output2. Now the Contrsaint for Outpu2 is like below: Output1.REJECTEDCODE = 0 And IsNull(Input.Field1) <>1 . Now I got the point that IsNull(Input.Field1) <>1 means Input.Field1 has to be NUL...