BASIC Routine to Convert datatype

[krystlecsy]

Hi all,

We are using a BASIC Routine to execute a SQL script and retrieve the input and pass into the next job. Now, the problem is the retrieve input is a STRING datatype but I need it to be a NUMBER datatype instead. Is there anyway to convert the input from STRING to NUMBER in the Basic Routine?

I have tried to Ans = Num(Input) but it assigns 0 to it.

Help!!

[chulett]

The Num() function checks to see if something is numeric or not... interesting that the answer it returns for you is 0, aka false.

In BASIC, doing math on a string does an implicit conversion so the typical trick is to multiply the field by 1.

Not sure how well this all plays out in a Parallel job.

[roy]

Hi,
I don't think you can effect the type of the returned Ans variable like that,
However you can try declaring it in your routine as integer and try to see if it helps (this is a long shot).
Other then that the only thing you can probably do is use modify or transformer stage to convert that string to a number or the other way around (convert the number you have to a string to match the returned data typr from your basic routine.

IHTH,

[ray.wurlod]

BASIC doesn't have data types, so the answer is properly no. Pass the value as string into your parallel job and convert it there.