DSXchange

Hi, I am trying to use Exec command stage to pull data into a parameter as a list for use in an SQL DB2 query. My command is: type \\Nho04\myfilepath.txt Which is found and has imported my data. The query is as follows: SELECT CTR_POL_NUM, CTR_RSA_TOT_PREM FROM DMIDBO.CTR_TRANSACTION WHERE CTR_SOURC...

Re-opened this post because I have a question regarding the FUNCTION PolicyList(PoliciesFile) script you recommended Ray. I understand #PoliciesList# will reference the function, however where do you suggest I actually write the FUNCTION section? Within the SQL area of a DB2 stage after the SELECT s...

Thanks works perfectly. I will mind the parallel vs. server jobs next post. Thanks ArndW.

Hi, Simple Question that I cannot find info for: How do you pull specific chars from a string based on their position? i.e. "abcdefg" -> I want to pull position 4, which will return 'd' in this case. I know for the above example Right('abcdefg',4) returns 'defg', however I only need the si...

You guys are salesmen and scholars I see . I have informed by boss of the high quality of support your site provides. We will see if he clears the user purchase. Who knows, may lead to multiple users

Any chance I can see the code in the mean time? lol

so i guess this is where the premium content comes in lol.

Hi, I'm writing an SQL pull from a DB2 database as follows (not completely debuged but u get the picture): SELECT POLICY ,DEC (SUM (TBASICPRM), 12,2) FROM CMIDBO.PREMTRAN WHERE COMPANY = 1 AND PRODUCT IN ('COM' , 'FRM') AND POLICY IN (119102207 ,628332100 ,855064102 ) GROUP BY POLICY WITH UR ; What ...

Those were all very good ideas. In the end the Iconv() worked very very easily.

Thank you all for your help I really appreciate it! This message board will be getting some good recommendations from me .

Cheers,
Adam Love

The string manipulation worked well, however is there a better command than len(in.col) as it returns the max length of the string, not its current trimmed length (just wondering). Also, I agree that with a proper datatype setup this would be handled much more effectively. However, does it matter th...

thats what i thought... any tips on accomplishing that ?

I can use Convert() to remove the end "-". But is there some type of boolean operator I can use to identify if this string is present? (so I can use this logic: If present then remove from end and put on front, else do nothing)

I just attempted it. I am recieving an error: APT_CombinedOperatorController,0: Numeric string expected for input column 'huon_prem'. Use default value. I am importing in as a varchar, data looks like: ".00"|"5084.00-" "203015.00"|"189710.00" (delimited by | )...

My apologies, it is an Enterprise Edition job.

Hi,

Just wondering if anyone knew of a good way to deal with decimal fields that, if negative, have trailing negative signs on import.

Ex:

1,234.05-
22,000.00

When converting from char to decimal it does not like the negative sign.

Any suggestions?

Thanks,
Adam

Thanks! Convert worked perfectly.

And Roy thanks for the welcome

Cheers,
Adam

Hi, I'm attempting to import a field containing commas as well as decimals within the number set . i.e. 123,020.13 987,876.00 The field is defined as decimal, however it appears it does not like the commas. I recieve the following error: Warning: Sequential_File_0,0: Field "huon_prem" has ...