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.
Search found 17 matches
- Fri Aug 19, 2005 3:23 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: sequence generated for the primary key
- Replies: 2
- Views: 1650
- Thu Aug 11, 2005 3:18 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Alternate to IF-statement
- Replies: 7
- Views: 2661
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 ...
- Thu Aug 11, 2005 2:06 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Alternate to IF-statement
- Replies: 7
- Views: 2661
Alternate to IF-statement
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...
- Wed Aug 10, 2005 8:54 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Identify recent record by date
- Replies: 10
- Views: 2962
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,...
- Sun Apr 10, 2005 7:11 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DSExecute
- Replies: 10
- Views: 3898
- Sun Apr 10, 2005 12:06 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DSExecute
- Replies: 10
- Views: 3898
- Sat Apr 09, 2005 6:48 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Is there a way to remove characters from String except 0-9
- Replies: 4
- Views: 2785
- Sat Apr 09, 2005 1:36 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DSExecute
- Replies: 10
- Views: 3898
- Wed Apr 06, 2005 7:40 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DSExecute
- Replies: 10
- Views: 3898
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
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
- Wed Apr 06, 2005 3:37 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DSExecute
- Replies: 10
- Views: 3898
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...
- Wed Apr 06, 2005 1:12 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DSExecute
- Replies: 10
- Views: 3898
DSExecute
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...
- Sat Mar 26, 2005 7:14 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Arabic NLS from Excel sheets
- Replies: 5
- Views: 3463
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 '?...
- Sat Mar 26, 2005 12:38 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Arabic NLS from Excel sheets
- Replies: 5
- Views: 3463
Arabic NLS from Excel sheets
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...
- Mon Mar 21, 2005 7:38 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Multiple Excel files for input
- Replies: 2
- Views: 1207
Multiple Excel files for input
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 ...
- Fri Feb 06, 2004 5:54 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: can link collector stage be used with out Link partioner.
- Replies: 5
- Views: 2445