Search found 42189 matches

by chulett
Fri Apr 04, 2008 6:56 am
Forum: General
Topic: SQL server varchar to Oracle date format
Replies: 4
Views: 1735

For the second, you need to transform the SQL Server timestamp to conform to what Oracle is expecting, that or use your own sql with a matching 'date format picture'.
by chulett
Thu Apr 03, 2008 10:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: routine or stage
Replies: 2
Views: 1555

Compare that to the heretical action of quoting the entire original post just to add your advice. :wink:
by chulett
Thu Apr 03, 2008 10:18 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Import SQL Server Stored Procedure
Replies: 4
Views: 1121

Could you not do your grants and import in another environment where that is less of an issue, development for example?
by chulett
Thu Apr 03, 2008 4:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Avoiding sending emails from a Datastage Server/Project
Replies: 2
Views: 971

No to both. I've found the best answer is to always parameterize things like that and make sure that - outside of production - all of the emails come to the developer(s). Or the QA folks.
by chulett
Thu Apr 03, 2008 1:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: convert to xml file
Replies: 18
Views: 5623

Fixed width recods and char fields cannot be trimmed like that. Why not use varchar?
by chulett
Thu Apr 03, 2008 9:21 am
Forum: General
Topic: Migration of Oracle Database from 9i to 10g
Replies: 3
Views: 967

Well, even if it doesn't happen, you should be fine using a 9i client to access a 10g database, we do that here as we also have 9i databases to support.
by chulett
Thu Apr 03, 2008 9:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Appending Header to Target File
Replies: 2
Views: 747

You can't cat the header onto the end of the data, you need to cat the data onto the end of the header. Either that or cat them both, in the proper order, to a new file. I'd suggest the latter.
by chulett
Thu Apr 03, 2008 9:10 am
Forum: General
Topic: Migration of Oracle Database from 9i to 10g
Replies: 3
Views: 967

You're fine. Will you be upgrading the client version of Oracle on the DataStage server as well?
by chulett
Thu Apr 03, 2008 8:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Query for Tertial(4 months)
Replies: 4
Views: 1488

:wink: Left that for you to post, Ken.
by chulett
Thu Apr 03, 2008 8:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Running the jobs in sequence and looping upto certain time
Replies: 4
Views: 1155

You schedule the job using the Director and can simply 'Add to Schedule', over and over, at five minute intervals. Not ideal, but would work as long as your job never takes more than five minutes to run!
by chulett
Thu Apr 03, 2008 8:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Query for Tertial(4 months)
Replies: 4
Views: 1488

So... you are just asking if there is a 'tertial' version of this to_date function? to_date(trunc(sysdate,'Q')) I have no clue, but if it was me I'd take this question to my Oracle DBA. I also couldn't find an official name for a 'four month period' or one-third of a year, but it doe...
by chulett
Thu Apr 03, 2008 8:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Memory leaks on Linux
Replies: 4
Views: 1388

Something like memory leak issues would need to be taken to IBM for resolution, I would think. See if it is a known issue on that platform and if perhaps a patch is available.
by chulett
Thu Apr 03, 2008 8:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to create a dummy xml file
Replies: 4
Views: 1231

Right now, what does get created when you have no input?
by chulett
Thu Apr 03, 2008 7:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Illegal Variable name/number
Replies: 9
Views: 2024

sinhasaurabh014 wrote:Thanks!! Does that mean all the field/columns defines as a key has to be there in the where clause

Actually, the anwer is 'yes'.
by chulett
Thu Apr 03, 2008 7:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: reading of the fixed width file with Header and tail
Replies: 6
Views: 1534

If all you want are the data rows, can you not just define that metadata in the stage and anything that doesn't match - header,trailer - will automatically be 'ignored' by the stage, yes?