DSXchange

Hi we are facing problem when we are loading data into oracle table.stage used is oracle enterprise stage.error is below. Oracle_Enterprise_3,1: The call to sqlldr failed; the return code = 256; please see the loader logfile: C:/IBM/InformationServer/Server/Scratch/ora.6172.514000.1.log for details....

anbu wrote:

Code: Select all

x=26-FEB-10
svMon=UPCASE(Field(x,"-",2))
If svMon = 'JAN' Then '01' Else If svMon = 'FEB' Then '02' ...

Thanks for your reply

i will try it and let you know.

Hi,
I ahve rewuirement like this
how to convert 26-FEB-10 into 26/02/2010

So can anyone suggest me how to do this in parallel job.

Thanks in advance.

priyadarshikunal wrote:It should work on windows as well because of MKS Toolkit installed with Datastage.

Thanks for your reply

where can i use that suugest me please.

Thanks

Sainath.Srinivasan wrote:

Code: Select all

sed -e 's/\&/AND/g' yourFileName

...

THanks for your reply.

but here i am working on windows.So please suggest me.

Hi,
how to convert & into AND.

Can anyone please suggest me how to achieve this.

Thanks iun advance

Noting that you may need to modify the expression because of the space following the "-" character one solution is If Index(InLink.TheString, "-", 1) > 0 Then Field(InLi ...[/quote] Hi Ray, Thanks for your reply i am not premium user.If you dontmind can you please elaborate that...

Hi,
my requirement is like

Character after "-" should be Capital letter

Ex:

input:
hi this - is dsxchange forum.
output:
hi this - Is dsxchange forum.
Can anyone please suggest me how to accomplish this.

Thanks In advance.

Thanks

ray.wurlod wrote:Can you please give us some examples of input and expected output?

Are you trying to generate a check digit on an International Standard Book Number?

i am sorry my logic was wrong.Just now we changed the logic,i didn't get negative value.Anyway thanks for your support.really sorry ...

THanks

Yes, of course it will accept negative numbers. I must admit, however, your derivation confuses me... you multiple 9 by 0? To what end, just to get a zero? And then set a variable to either an 'N' or a negative number? Kind of an odd way to flip the sign, if you ask me. :? Other than that, why the ...

Hi, I have stagvariable like If (IsValid("int32", Sv9Digits) And(IsValid("string", Sv10thChar))) Then ((9*0)- (DSLink3.ISBN [1,1])) Else 'N'. First charecter is 1 then it will return -1.My doubt is whether datastage accept the negative numbers or not. Can anyone please help me on...

To quote a line from a movie: "You have chosen... poorly". Seriously, rethink what hardware you will need for your stated goal of supporting 30 users on the 8.1 release of this product - an XP system (an unsupported O/S for this tool, btw) with 2GB of memory is well below what your minimu...

ROFLMAO!!! 30 users on Windows XP ?!! What is the capacity of this alleged "server"? As far as I can recall the maximum amount of memory that Windows XP can access is 3GB. That's barely enough f ... Thanks ray. But 30 users using the server and server RAM is 2GB.4 applications are running...

ROFLMAO!!! 30 users on Windows XP ?!! What is the capacity of this alleged "server"? As far as I can recall the maximum amount of memory that Windows XP can access is 3GB. That's barely enough f ... Thanks ray. But 30 users using the server and server RAM is 2GB.4 applications are running...

Hi,
I want to install 8.1 version in windows xp,30 users will be accessing the server.So what is the server configuration should be.

Thanks in advance.

Thanks
Pavan Kuamr.