Search found 10 matches
- Thu Apr 29, 2004 3:00 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Encrypting the Flat File
- Replies: 5
- Views: 2424
- Mon Apr 26, 2004 9:27 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage installation
- Replies: 5
- Views: 2083
- Fri Mar 05, 2004 10:05 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DS SERVER/CLIENT PROBLEM - too slow
- Replies: 4
- Views: 1897
I agree that your job is way to big, do what ogmios suggests and break it down into smaller jobs. Also when comparing loads into SQL Server and Oracle, SQL Server is pants and Oracle will always beat it. The fact that you have both DS and SQL Server on the same machine is also cause for concern, tha...
- Fri Feb 20, 2004 7:39 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sequential files access
- Replies: 3
- Views: 2089
I'm trying to access them through designer, I have a sequential stage and I can't look at the data. The message I get is: DATES..Sequential_File_0.DSLink3: DSD.SEQOpen Failed to open Prospects.txt in directory Q:\AUTOMATION\BBCSHOP STATUS = 22. Don't worry about the goat, I have have some chickens a...
- Fri Feb 20, 2004 5:46 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sequential files access
- Replies: 3
- Views: 2089
Sequential files access
Guys, I'm having a big problem trying to access sequential files on different servers. I've looked through the forum and tried everything that has been suggested, this includes: Stating the user in the schedule tab on DS administrator Looked at uvconfig to make sure ALLOWNFS is set to 1 Sacraficing ...
- Thu Feb 05, 2004 3:07 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Date conversion
- Replies: 7
- Views: 3647
- Wed Feb 04, 2004 11:51 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Date conversion
- Replies: 7
- Views: 3647
- Wed Feb 04, 2004 10:59 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Date conversion
- Replies: 7
- Views: 3647
Date conversion
Hi,
I'm having a problem with dates, I have a date in the format of:
yyyy-mm-dd 00:00:00
I need to convert it into the follwoing format:
dd/mm/yyyy 00:00:00
Can anyone help me?? These date conversions are driving me crazy!!!
Thanks
Willo
I'm having a problem with dates, I have a date in the format of:
yyyy-mm-dd 00:00:00
I need to convert it into the follwoing format:
dd/mm/yyyy 00:00:00
Can anyone help me?? These date conversions are driving me crazy!!!
Thanks
Willo
- Thu Jan 29, 2004 8:00 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Comma Delimiters
- Replies: 2
- Views: 1301
- Thu Jan 29, 2004 6:39 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Comma Delimiters
- Replies: 2
- Views: 1301
Comma Delimiters
Hi,
I have a column that has a comma that I need to seperate, eg the column looks like:
123719,27319
I want to seperate them into 2 seperate columns, I want to this in a transform. Could anyone help please??
Thanks
I have a column that has a comma that I need to seperate, eg the column looks like:
123719,27319
I want to seperate them into 2 seperate columns, I want to this in a transform. Could anyone help please??
Thanks