DSXchange

ray.wurlod wrote:The server node name is exactly what is says; the network node name of the machine on which the UniVerse or UniData database is running. If this is the same machine as DataStage server, you use that m ...

Thanks for your reply.

Thanks
Krish
---Fan of Ray

UniData is a different database; you won't be able to import those unless you have a UniData database system visible to your PC. I think you are lokoing for UniVerse hashed files. ... ArndW Yes, you are right, i am looking to import UniVerse hashed files meta data, there it is asking for Server Nod...

Hi All How are you doing today ? I am using datastage 7.5 and widows XP in my PC.Both server and client are installed on same PC Firstly i am trying to Import meta data for Uni data files.(Hashed) Im my server jobs. When i tried to do so, new window opens and it is asking for Server node name. What...

kumar_s wrote:Since you are doing a string Manupulation, add qoute around 18 from the given solution.
Left(cloumn_name,4):'18':right(cloumn_name,2) ...

Thanks a lot

can we have any routine to do this, b'cos i have to use this in diffrent jobs

Thanks

All I had an issue with date conversion My source file has date formet 'mmddyy' and i need to send to target in other formet lilke mmdd18yy means everytime i have to add 18 to source data and send the data Is there any function in ds do this for me or should need to write any routine for this. pleas...

chulett wrote:The lookup will work with an 'empty' value, but not with a NULL. For nulls, you'd need to translate that to another unique value (both sides) and use that for the lookup. For example, perhaps '*'. Do ...

Thanks for your Help

You didn't answer my question. What should happen in that case? Then we'll see about implementing it. ... Hi I got your question now. i have all posible entries in my look up table it has A, B with null on it so it has to match with that and retun the C , But its not doing that if c has null value ...

Short answer, you can't. How about you tell us your requirements - what should happen when B is null? ... Chulett Thanks for your respose. As i said i have all posible enries to A,B in my reference table say A B C A B1 xxx A B2 xxx A xxx what i has to do is i have to check these fields if both matc...

All i have an issue with data conversion in one of my lookup jobs source file has two fields let us assume A,B lookup file has three fileds C,d,e my issues is I have to send the 'e' to target if 'A' matches to 'C' and 'B' matches to 'D', it does matches then i have to send A to target. i have define...

I am extreamly sorry for putting my subject as urgent. We do not do "urgent" here. DSXchange is an all-volunteer site whose participants post as and when they can. If you want "urgent" or "immediate" help, sign up with your support provider for premium service and learn...

I am extreamly sorry for putting my subject as urgent. We do not do "urgent" here. DSXchange is an all-volunteer site whose participants post as and when they can. If you want "urgent" or "immediate" help, sign up with your support provider for premium service and learn...

Hi All I have total of 7 jobs that pick up data from webservices and put in my oracle table. these jobs are running good from past few months.As i said before today we tried to test with bulk data. My job design is like webservices client(source)->xml input->transformer->seq file->oracle out 7 jobs ...

Hi all Once again with my problem Here we are you using datastage 7x server jobs with webservices pack we are using webservices client as source and connecting to website(we pick up source data from website) and transfrom that data and loading into our staging table. This my first sequecer job , in ...

Thanks for your valuble suggestions,

I will try this way and let u know if my prob is solveds

Thanks
Krishna

Good Morning all and wish u happy new year Secondly, we are using datastage server jobs with 7x release I have issue with my job sequencer. In my process i have job that writes data in flat file, in the next step we send that file to other server via FTP. Some time we don't process any records, at t...