DSXchange

I am trying to FTP a EBCDIC file to Mainfram system and the file looks good when viewed from EBCDIC file viewer but when I FTP the file , the fixed length is distorted 00501 100 RECPT/WAIT OFFICE SUPP 010221 0000 00501 100A COPY OFFICE SUPP 010221 0000 00501 100B CONF CONFERENCE 010221 0000 00501 10...

hi i am getting this error while i am trying to insert records in to Oracle Enterprise usinfg auto generated insert then update.

Unable to use a record for update due to ORA-00060: deadlock detected while waiting for resource

Ray, I could not get your point , can you please eloborate it and also I would like you to note that first one is my Look Up Table and Second one is my source data.

Thanks

Hi , 1.As seen below #1 is my lookup Table with '*'s in it which means accept any value from the source and #2 is the source and output as desired, Can you please suggest me the simplest solution.One way is Look up Exact Values then do another look up on Rejected values and then another Lookup on Re...

Thank you very much for ur reply Ray...

Yes i did...
with options set as..
routine name: ObjectTesting
external subroutine name: ObjectTestOne
library path : /modl/apps/fold/dsdata/common/bin/ObjectTesting.o
object type : object

Hello...i have written a parallel routine for the first time and i'm facing problem in running it. i want ur help in resolving the issue. here are the details regarding the routine... ObjectTesting.cpp: #include <stdlib.h> #include <stdio.h> #include <iostream.h> #include <stdcomp.h> char * ObjectTe...

Description:- I have a Object,Date_From,Date_To,Area in my lookup file,Which is a slowly Changing Dimension,So I will have many records for each Object, and In My Source Dataset, I have Object,Date. Requirement:- I need to do a lookup on Object and say we get 3 records from this Lookup, now I need t...

check system requirements for v8

Thanks all for your help,This is the Server Routine PartNo = TrimB(Arg1) MaxLen = Len(TrimB(PartNo)) AlphaCount = MaxLen pos = 0 LOOP WHILE pos < MaxLen if Alpha(PartNo[(MaxLen-pos),1])=1 then pos = pos + 1 AlphaCount = AlphaCount - 1 end else Goto EndofLoop end Repeat EndofLoop: Ans = PartNo[1,Alph...

girija wrote:Use LEFT fiunction if you want to stirp last three (fixed) character from your input value.

Thanks Girija, sorry for the incomplete information.

There may be any number of Chars at the end (1,2,3 or 0.)

Hi
I have a Material Number like 123AB456DFG, and I have to strip the chars at the End, so output should be like 123AB456. Previously I wrote a basic Routine and now we want it in Parallel transformer.

Can you guide me in doing this...

Thanks

Hi

I have couple of questions on quality stage.

1.How to create rule sets for date,time,phone,email.Because i didn,t find any predifine rule sets for these.
I found for address,name....
So please give me reply that would be appreciated.

SURA wrote: was installing SQL server

Hi Sura,
I think SQL Server should not be installed on the same machine, I don't remember why but I am sure I read it somewhere.

Guy's Correct me If I am wrong.

Mine is very funny...! I was on bench for 3 months with VB.NET Skills, then installed DataStage on my laptop and learnt on my own and happy ever after....

First of AllI would seperate the values based on the delimiter to different columns like then Use a Pivot stage to get your desired output