DSXchange

Does'nt SQL Server take timestamp in YYYY-MM-DD for date and MTS format for time? Does the following work for you guys OCONV(ICONV(Field(in.DATE, " ", 1), "D/DMY"),"D-YMD[4,2,2]):" ":OCONV(ICONV(Field(in.DATE," ",2)...

So basically for input Target1 10 Min1 20 Max1 30 UOM mm comment Target2 101 Min2 201 Max2 301 UOM cm comment the output should look like. Is my assumption correct? If not give us the first 12 lines of your file and how it should look like. Target1 10 mm Min1 20 mm Max1 30 mm Comment Target2 101 cm ...

Ok, I thought it was to be reset to 1. My bad. Use the following cond | if @INROWNUM =1 then 1 else if (in.STATE:in.CITY:in.ZIP= PrevThree) AND (in.SALES <> PrevSales) then cond +1 else if (in.STATE:in.CITY:in.ZIP= PrevThree) AND (in.SALES = PrevSales) then cond else ...

just4geeks wrote:So, wouldn't increasing the swap memory have a chance in resolving the issue?

Don't guess. Let support handle it. Maybe they will say the same thing. You can try it but I highly doubt it. As memory might be present, but still out of reach.

Cute......

ganesh123 wrote:DHANYAVAD SIRJI :D

...means, "Thank You Sir" with respect

How many times UOM will be present in the file. As in if I were to implement this using a script, and I want the UOM value, is it safe for me to do a grep on UOM and get the value, 'mm' to attach to all the columns except 'comment' ?

Yes, 'ExecSH'.

chulett wrote:

DSguru2B wrote:In the constraints, scroll right, you should be able to see 'Abort After' column.

Fixed that for ya.

Thanks Craig.

In the stage variables, scroll right , you should be able to see 'Abort After' column. If you dont have that, then you can utilize UtilityAbortToLog() as others have noted.

So narasimha, you stay in NY and work in CO ???
Craig, can you make me your disciple as well

It is possible that the error might occur in one environment and not the other. Search for Segmentation Violation for a better understanding on what it means. Basically your code is trying to access memory thats illegal or out of reach.

I think it would be safe to presume as both work under similar concepts. But you definately need to take this to support.

You are correct.

There are a bunch of sed one liners that can be found on google. Search for 'em.