Search found 26 matches
- Mon Sep 27, 2010 9:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to create header and trailer record in output file
- Replies: 4
- Views: 3509
- Fri May 02, 2008 12:12 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Corrupted DS_JOBOBJECTS hash file
- Replies: 3
- Views: 2182
Thanks for your response. I am on Windows not Unix, but your response should work either way. I was hoping there is a way to rebuild the hash file rather than fix it. The fixtool sometimes deletes records if it can't fix them. I'm not sure how I could tell if I lost some records from the file. I mig...
- Fri May 02, 2008 9:39 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Corrupted DS_JOBOBJECTS hash file
- Replies: 3
- Views: 2182
Corrupted DS_JOBOBJECTS hash file
I ran out of disk space and corrupted my DS_JOBOBJECTS file. Is there a way to rebuild it?
- Fri Aug 31, 2007 7:01 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Teradata TimeStamp to Oracle Timestamp(9) -- 12 hour format
- Replies: 2
- Views: 3259
Teradata TimeStamp to Oracle Timestamp(9) -- 12 hour format
Having trouble converting - '2007-08-13 02:59:13.730829 PM' to an Oracle 12 Hour Timestamp Have tried to_date('yyyy-mm-dd hh:mi:ss.ff6am' (among others) can't find any documentation
- Fri Apr 27, 2007 11:32 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error while Hash file creation
- Replies: 6
- Views: 4428
Have had this before
had a phantom running you have to cancel all processes running against the file. You may have to go into administrator (or uv) do a list.readu to determine user id and processes and end processes and release user.
- Thu Jan 18, 2007 12:05 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Hashed Lookups and Data Availability
- Replies: 8
- Views: 3021
Hashed Lookups and Data Availability
If I do a lookup to a hashed file and my output order is such that I write to the same hashed file before using the data looked up is the original data from the lookup still available to me or do I have to either save it to a staged variable or change the re-write of the hashed file to occur after I...
- Mon Nov 20, 2006 5:14 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Embedded Line Feed in DSSendMail Attach Path
- Replies: 2
- Views: 2439
Embedded Line Feed in DSSendMail Attach Path
I have a dssendmail with an attachment that I am having a problem with -- the path of the attach contains 2 \n's -- attach:g;\tst\sdw\nww\nwwvndrxxx.txt the jobs gets to the first \n and treats it as a line feed is there any way around this.
- Mon Oct 09, 2006 6:09 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: validate date and populatate
- Replies: 4
- Views: 2730
Validate
You could always do an Iconv and the Status() to check if it was a valid date to convert conversly if it is valid you could use an Oconv and concatenate a dummy timestamp to the end of it.
- Wed Oct 04, 2006 5:13 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Compilataion error in Sequencer
- Replies: 3
- Views: 1729
Error 2017
This has been discussed before. Please do a search using the 2017 and you will find the answer to your question. A search for the answer should always be done before posting a question.
- Tue Sep 26, 2006 1:47 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Read/Write Cache Size
- Replies: 1
- Views: 1540
Read/Write Cache Size
Is there any rule to set an optimal read/write cache the default is 128mb but I seem to get an increase in speed by increasing these. Is there a limit after which I will take a performance hit??
- Mon Sep 25, 2006 8:12 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: job access
- Replies: 5
- Views: 2738
Which User
From NT If you have admin you can do a LIST.READU
- Fri Sep 22, 2006 1:12 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: parametrizing the arguments of cat command
- Replies: 7
- Views: 2324
Cat?
Why use a before/after subroutine of cat a,b > c when you can (provided formats are the same) use a link collector to do the same work in the job.
- Fri Aug 25, 2006 6:01 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: TeraData API Lookup based on a flat file
- Replies: 6
- Views: 3615
problem??
If you pass the value to a teradata api filling in on stage tab teradata director(server) UserId and password for logging in to teradata. give it the table name and user defined sql to select the record using (passed field(field type) and a select from where field = :(using field name) it should be ok
- Fri Aug 25, 2006 6:01 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: problem??
- Replies: 1
- Views: 1808
- Fri Aug 25, 2006 5:50 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: problem??
- Replies: 1
- Views: 1808
problem??
If you pass the value to a teradata api filling in on stage tab teradata director(server) UserId and password for logging in to teradata. give it the table name and user defined sql to select the record using (passed field(field type) and a select from where field = :(using field name) it should be ok