DSXchange

DSguru2B

Now thats neat

DSguru2B

Nothing out of the box but you could write your own. Something like

FUNCTION myCharReplace(myString, repChar, Pos)

charToReplace = myString[Pos,1]
Ans=Ereplace(myString, charToReplace, repchar, 1, 1)

DSguru2B

Running the job immediately after it failed is not going to do any good. You should consider putting the sequence to sleep for a few minutes and then re-trying. Consider having a routine activity which has something like sec = Arg1 SLEEP sec Ans=1 Let the routine activity connect to your job. Enclos...

DSguru2B

Its not a dumb question Brad. It never hit us. The OP can also use

Code: Select all

sed 's/.$//' mydosfile.txt > unixfile.txt

DSguru2B

Yes, that was fixed in 7.5.1A and higher.

DSguru2B

Because the OCI stage (server job) has that option and not the Enterprise stage(px job)

DSguru2B

User the modify stage to get your conversion done.

Are you using the OCI stage or the Oracle enterprise stage. If the latter then i dont think you have that option.

DSguru2B

store it in a stored procedure, I'm . The OP did not specify that the data is being extracted from a db table. I guess you assumed. Hope it's right. Or did I miss something? Whale. What a bummer. I meant stage variable. I was thinking of stored procedure while i was typing out my reply and hence my...

DSguru2B

Concatenate the first two columns, store it in a stored procedure, check with incoming, if its same, increment the counter else reset to 1. Search this forum, this has been covered gazillions of times.

DSguru2B

User AsInteger or StringToDecimal() function to convert your character field to integer.

Yes,You can certainly do insert/update in parallel jobs.

DSguru2B

O, the switch over, the switch over, why didnt it hit me, for some reason i thought something was going wrong on my end.
Well Sheema, thats a routine by Ray, so you could request him to make it visible for a day so that it can help you.

DSguru2B

You cannot see this http://www.dsxchange.com/viewtopic.php? ... valid+date

DSguru2B

Check again. I made them visible for now. You are 25 posts into your membership. You should really consider becoming a premium member as you get routines written by others and basically solution to your problems in a silver platter.

DSguru2B

Why not just save the xls sheet as csv and then use it. Who ever is responsible for creating these sheets, request them to send you a csv copy. Usually 'they' dont mind.

DSguru2B

Check this link out.

Search found 6797 matches