DSXchange

cool. Thanks guys.

Well, i was hoping i could achieve this by some DS functionality. I already have the logic to manipulate the string using IF/then and substrings. But thats my last option. If nothing else comes to my attention then that would be my course of action.
Thanks Arnd.

amsh76 the ICONV/OCONV for the MT only works if i have the time in the actual time format. (either one of the few listen in the server manual) my problem is with the way the time is coming in. Its in a string format, the ICONV/OCONV functions spit out a 0 if i feed in a time that coming in the forma...

thanks for the quick reply, but there is a problem with the use of substring.
what if the input is 11320000
this is suppose to be translated to 01:13:20.000
but if i do a substring of the first two places, its going to give me 11
???

Hi guys,
I have the time coming in a string format. eg
12:31:32 is coming in as 123132000. Is there a function or routine in DS which reads in this string and gives me the output 12:31:32.000
Thanks guys.

With the job control theres a small little problem. I am copy pastying the job control of this particular sequence into a job, i dont think you can edit job control in the sequence itself. now if the new job with my edited job control fails. i need to compile it again. that again loses restartability.

yes that is true but that defeats the purpose of it being restartable. isnt there any way to handle it within the sequencer job.

Hi guys, I am stuck in a situation right now. i built a sequencer with three jobs in it J1 --> J2 ---> J3. they run sequentially upon the successfull completion of its predecessor. From each of these job activites i have a link going to a sequencer stage specifed to 'Any'. The sequencer is then conn...

Hi guys, I have a job that determines the inserts. our target table generates the id on the database level when an insert command is issued to it. Once my inserts are successful and the ids are generated, i have to get that id and use that id to update the mapping table. The problem is that my targe...

It works. Thanks guyz.

I have a column where the length of the field has to be 6. if it is less than 6, i have to keep the length of the field as 6 and add zeros on the remaining field. I am checking the length of the field by the Len() function. but how to put that many zeros in that field. Can it be done within the tran...

I have a column where the length of the field has to be 6. if it is less than 6, i have to keep the length of the field as 6 and add zeros on the remaining field. I am checking the length of the field by the Len() function. but how to put that many zeros in that field. Can it be done within the tran...

Hi guyz,
I did some research on it. MSSql Server Load plug in is windows platform specific. Only if the DS server is on windows, only then that plugin is useful. I wonder why its confined to only windows??
anyways, thanks guyz.

Hi guyz, Have a simple question. We are using sql server as our target database. Uptill now i was building jobs using the DRS stage. I have asked them to install the MSSql server load stage. I believe it will increase the performance as it uses sql server's native driver. But i just found out that m...

Great....Thanks buddy!!!