DSXchange

Hi Ray, How are you doing. It is a paralled job. I have my job like this in seq stage Col1 Varchar(256) 0.0 0001.09130000000000000000000000000000012 9999999999999999999999.99999999999999999999999999999999 123456.1234567 Tranformer Out col1 Decimal(10,10) col1 = StringToDecimal(col1) Peekstage out pu...

Hi I am trying to convert a string1 varchat(256) = 010.0009898878999890 to field1 decimal(20,20) .I used stringtodecimal(string1,"ceil") function for field1 derivation. getting 100e23 when trying to see in the sequential file(even using vi editor or cat) or dataset. I think I can resolve t...

what are the datatype check functions available in 8.0 transformer.
like Isnumeric,Isalpha,Isdate etc.,

Hi
I am trying to get the data from DB2 using API stage .
I am selecting a field datatype is date and in result it showing the date as below.
14792 (2008-06-30)
But I am expecting only (2008-06-30).

Please let me know how can I eliminate the Internal date representation(14792)

Thanks

The BASIC function "EREPLACE()" will do this, but it does not exist in PX. What problems do you have with the BASIC transform stage at V8 - I have seen that it works quite well and no longer shows sporadic comms issues as it has in the past. I have tried Ereplace function its working fine...

Hi Please help me in handling this conversion I would like to convert single char to 3 or 4 character in a string. Ex: if I have string like below 'test convertion from and symbol to may&be or & and percentage to may%be or % ' That Should be converted to 'test convertion from and symbol to m...

Thanks a lot Craig,

Its Worked :D You mentioned to remove @FM in your first reply only But concentrated more on [1] and troubled you.

Once again Thanks for your time and sharing your immense knowledge with us.

Hi Craig, I tried this one also but its giving error at compile as Exprected:expression Then I replaced <> with [] and compiled. ( I am using Version '8') UpCase(trim(Execute_Command_16.$CommandOutput<1>)) = 'XML' also tried Substrings(UpCase(Trim(Execute_Command_0.$CommandOutput )),1,1) = 'X' Subst...

Hi, I tried In execute_command stage and Nested_condition stage. giving below conditions but still its not working. UpCase(Trim( Execute_Command_16.$CommandOutput[1]))="XML" Execute_Command_16.$CommandOutput[1]="xml" UpCase(Trim( Execute_Command_16.$CommandOutput[1]))='XML' Execu...

Hi, I tried In execute_command stage and Nested_condition stage. giving below conditions but still its not working. UpCase(Trim( Execute_Command_16.$CommandOutput[1]))="XML" Execute_Command_16.$CommandOutput[1]="xml" UpCase(Trim( Execute_Command_16.$CommandOutput[1]))='XML' Execu...

Hi Craig, Thanks for solution. I got one problem in comapring the script out put. The out put of th script is not matching with my condition though the output is same as I have given in the condition. It is not executing the link with condition which should be true but executing other link(DSLink2)....

Hi Craig,

Could you please tell me how to write a parallel routine to Read the below file \data\outfile.txt and "field 2" value of the first line.

outfile.txt file contents:
Craig,2,91883
Roy,2,909-88
john ckenix,2,23411
smith,2,12142

Hi Craig,

Thanks for the Solution.
Could you please tell me Is it possible to assign a value to the job parameter in job and use that parameter later in other job or sequence.
Also Please let me know is there any sample routine to read the file and return some value.

Hi, Please help me creating a sequence that will execute based on the value of the file generated in the process. We have 3 jobs. job1, job2 and job3. Job1 will read source and write to a sequence file. sequence file will have one field called TYPE. It will containe 1 or 2 for all the records in the...

I have both quotes ' " in the value sting. ex: ' "&fieldname#1"="rama's" ' Please let me know how to handle these quotes and special characters.