DSXchange

Execute the following from Administrator:

UPDATE SDKSequences USING DICT VOC SET F1 = '100' WHERE @ID = 'Your_Sequence_Name';

Then just use KeyMgtGetNextValue('Your_Sequence_Name') in the derivation for your primary key.

The Case statement would make the code nicer as well as putting it into a routine. However a routine drops my performance. For every record coming through it's going to call that routing and run through the case statement. The IF is in a transform derivation at the moment. Thinking that it might be ...

I'm cleaning up some job code and the large if statements I've used are starting to bug me. For one they'll be hell to maintain in the future. Is there any alternatives to using IF's ? For example I have an IF that'll take a look at the Product name and then allocate it a batch number as the records...

Not quite sure what the actual question here is, but if I understand correctly you want the record with the max date if it gives you 4 occurences ? If you want to do it in DS instead of doing it in the Database's SQL (which would be the better way of doing it), try an order by clause in your source,...

Roy,

I'm not sure if I should kiss you or thank you... for now I'll stick with just thanks :)

It finally works.

Arnd, thanks to you too. Your solution was correct I just couldn't figure out how to implement it.

SourceFileName = 'E:\development\Source\':"FileName" TargetFileName = "E:\development\Source\Source.xls" CommandString = 'Copy /Y ':SourceFileName:' ':TargetFileName Call DSExecute("DOS", CommandString, Output, SystemReturnCode) Ans = SystemReturnCode Return (Ans) This ...

Only way I've been able to do it was to write a routine that check each character and if it's not A - Z or 0 - 9 then it would skip it and continue to the next. If it is one of the wanted characters, it would concat it to a new string and at the end of the routine pass back this "cleaned up&quo...

Embedded spaces in the filename doesn't work either so I'm assuming the double-quote fix is a must. Problem is everytime I used it, it uses the variable name (FileName) as the value. It doesn't resolve the variable first and then add double quotes to it. I've even tried concatenating a " charac...

Hi Arnd

I've tried with the double quotes but it still won't work.

Do you perhaps have a dsx export of the program you used and could you mail it to me ?

My email address is kn-mhenderson@se.com.sa

Thanks for all your help so far. It's appreciated :D
Morne

Nevermind *sigh* It's the arabic characters again... I've placed the following in a routine ************************************************************ FileNameLength = Len(trim(FileName)) UnQuotedFileName = trim(FileName)[2,FileNameLength - 2] CommandString = 'Copy /Y E:\devlopment\Source\':FileNa...

Hi I'm trying a simple dos command using the DSExecute command. However I keep getting a return code of 1 meaning that it doesn't find the command. The command is a simple 'Copy' but it can't find it. Anyone have any kind of explanation for this ? Also, what kind of security/priviledges do I need on...

Hi I used 'View Data' at the start but figured that the viewer through DS might be wonky since reading from a SQL Table gives me the proper characters. So I wrote the Excel sheet via DataStage to a Sequential file. Opened the file in MS Word, the characters are still not correct as they appear as '?...

Hi Following from my multiple excel sheet question, I have the following. The excel sheets I'm trying to load are in arabic. I've tried every single arabic map in NLS but still it refuses to pull those characters into DS. Did I miss something ? According to the documentation the ISO8859-6, MS1256 an...

I haven't tried it yet but I thought I'd post here for someone to give me a sanity check and tell me I'm not over-complicating things :D What we're trying to achieve is loading multiple excel spreadsheets into a SQL server database. The formats are the same but the names are different. I'm thinking ...

Just ignore the collector stage and link directly from your Transformers to the Sequenctial File. Just make sure that the settings inside the sequential file stage are the same for all three input links. And of course, change the 'Overwrite' setting to 'Append'