DSXchange

Hi,

Super, this is what I needed

Thanks!!!!

Hi guys, I was wondering if there is a smart way to add minutes to a date to form a timestamp. I want to create a routine that has 2 parameters, one for the Date/timestamp (when a date is entered with no time 00:00:00 is set as default time) and one for the minutes to be added. I cant simply concate...

Well, it seems it was just a NLS setting problem, it works fine now

Thanks for the help you guys!

Hi,

Thanks for the help I think where on the right track here, we added these settings to dsenv but still no success (the same char set as the database)
so I guess we will have to fiddle with this some more

Ill keep you guys posted, thanks for the help!

Hi, I have 2 tables A and B that are almost equal but need to be combined A.1 A.2 A.3 A.x1 A.x2 B.2 B.2 B.3 B.y1 B.y2 The result in table I needs to be: I.1 I.2 I.3 I.x1 I.x2 I.y1 I.y2 Since not all values need to be in A or B, the x or y columms need to be NULL when there is no match on the key col...

Whoops stupid of me..

Trim(String,' ', "A")

Thanks

Hi,

I just want to remove white space from a string but the StripWhiteSpace function seems to be missing? So can I use Trim?

Regards,
A

Thanks Ray,

Well that will take me some time :p 53 weeks times three years ha ha! :p

Thanks!
Kind regards,
Anthony

Hi guys, I'm hoping someone can help me :) i need to pivot a table like this: COL1 COL2 COL3 FIN1 FIN2 FIN3 The COL1 to COL3 collums don't need any special formatting the FIN1 to FIN3 need to be pivotted to REVENUE. So far no problem with a pivot stage. But here's the problem... FIN1 to FIN3 are lis...

Hi, When i compile a simple job that takes an Oracle stage a transformer stage (not required) and a Flat file stage to dump a database table to a flat file. It compiles, but when i try to run it it gives me the: datastage C Stage Plugin function "Get" required error... What can i do about ...

Hi chulett thanks for your help :) Unfortunately the flatfilestage keeps asking for an existing file :( the NUL file trick doesnt work like in UNIX or AIX based systems so it seems... I can write a routine that puts the contens of a directory in a file and then read this file but this seems like &qu...

Hi Ray thanks for the help

I tried and got this error message:
TestRegDir..SeqFile1.Dirfileresult: ds_seqopen() - Win32 error in CreateProcess() - The system cannot find the file specified.

I tried both .\NUL and NUL with filter dir -b c:\temp

Kind regards,
Anthony

Hi Chullet, Thanks your are right! that switch also works :) nice :) Ehm and about that \nul file if I use \null for the filename and dir -b #variable# in the filter of a flatfile stage I get an error that the \nul file cant be found (thats the whole point right? :p) Thanks for all your help :) Kind...

Hi ArndW, Thanks for your all your amazing help :) well I tried with the new code and when I started it directly with the TEST button with some known jobs it worked fine, but when i started it from the Job itself I got the same Abnormal termination of stage error. However there are 2 new entries in ...

Hi Thanks for the help :) well I tried the new code and ran the Job but it still gave me that Abnormal termination of stage error :( When i tested the code with the TEST button it worked fine for existing job names but when i left the Argument empty or if u used an nonexisting job name it gave me th...