Search found 41 matches
- Thu Nov 12, 2009 2:48 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Job Status in Server transformer
- Replies: 11
- Views: 5004
- Wed Jun 24, 2009 11:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to initialize Plugin
- Replies: 2
- Views: 2487
Re: Unable to initialize Plugin
I was able to connect to the sybase through ODBC, but when i try to connect to sybase through sybaseOC then i was getting a warning like Plug-in not initialized. I'd installed sybase client in the server where my Datastage server is mounted & made a entry in Dsenv file as below,even i was not ab...
- Wed Jun 24, 2009 5:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to initialize Plugin
- Replies: 2
- Views: 2487
Unable to initialize Plugin
Hi, I'd seen to all the posts regarding the same issues. Even though i'd set the variables as suggested in my Dsenv file,i was not able to connect to sybase using sybaseOC. My Dsenv file has entry as follows, SYBASE_ASE="ASE-15_0" export SYBASE_ASE PATH="/app/sybase/ASE-15_0/bin:/app/...
- Fri Apr 24, 2009 10:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Jobs aborted within a category
- Replies: 2
- Views: 1643
Jobs aborted within a category
I've some 800 jobs within a category.
I want to capture the jobnames of the jobs which was aborted within this category in a file.
I know dsjobinfo will help,but how to tweek the jobinfo to get the joblist which was aborted in a particular category.
Thanks in advance.
I want to capture the jobnames of the jobs which was aborted within this category in a file.
I know dsjobinfo will help,but how to tweek the jobinfo to get the joblist which was aborted in a particular category.
Thanks in advance.
- Fri Apr 24, 2009 3:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Splitting of Values into 2 or more lines
- Replies: 9
- Views: 7109
- Fri Apr 24, 2009 3:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Splitting of Values into 2 or more lines
- Replies: 9
- Views: 7109
Re: Splitting of Values into 2 or more lines
In Transformer, use 2 output links and write first 8 chacacter is first link and rest character in second link and then use funnel stage to combine both the output. Hi Nirdesh, Thanks for ur reply. But if in the case of my input having more characteres,which has to be written in more than two lines...
- Fri Apr 24, 2009 3:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Splitting of Values into 2 or more lines
- Replies: 9
- Views: 7109
Splitting of Values into 2 or more lines
Hi, I've a input file which holds a column of length 20 characters. I've to write it in the target which has the column length as 8 characters. So the first 8 characters should be written in first line of the column & the next 8 characters should be written to the nest line,..... But the values ...
- Mon Apr 20, 2009 4:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dynamically Creating Files
- Replies: 22
- Views: 10906
- Mon Apr 20, 2009 3:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dynamically Creating Files
- Replies: 22
- Views: 10906
Re: Dynamically Creating Files
This is not an interview question. It is my requirement. I was only allowed to use Parallel jobs & Sequencers to achieve this requirement. Once again Parallel jobs & Sequencers . Its confusing me. can you please answer my questions. We can use only parallel jobs & Sequencer Jobs(not ser...
- Mon Apr 20, 2009 3:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dynamically Creating Files
- Replies: 22
- Views: 10906
Re: Dynamically Creating Files
This is not an interview question. It is my requirement. I was only allowed to use Parallel jobs & Sequencers to achieve this requirement. Once again Parallel jobs & Sequencers . Its confusing me. can you please answer my questions. We can use only parallel jobs & Sequencer Jobs(not ser...
- Mon Apr 20, 2009 3:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dynamically Creating Files
- Replies: 22
- Views: 10906
Re: Dynamically Creating Files
This is not an interview question.
It is my requirement.
I was only allowed to use Parallel jobs & Sequencers to achieve this requirement.
It is my requirement.
I was only allowed to use Parallel jobs & Sequencers to achieve this requirement.
- Mon Apr 20, 2009 2:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dynamically Creating Files
- Replies: 22
- Views: 10906
Dynamically Creating Files
Hi, I've a requirement like of below, I'm reading a file where i've 2 columns (Column1 & Column2). If this file has 10 records,then i've to create 10 files where the name of files should be based on the values from the coulmn1 & the content of the file be the values from Column2. Example: My...
- Mon Apr 06, 2009 11:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CDC:Warning
- Replies: 3
- Views: 3145
CDC:Warning
When i was doing a CDC,I was getting the following warning, CDC_: When checking operator: Defaulting "Column1" in transfer from "beforeRec" to "outputRec". Where Column1 was coming from both before & after extracts. I also sorted & partitoned the data based on t...
- Mon Mar 23, 2009 10:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date Logic
- Replies: 3
- Views: 1782
Date Logic
Hi, I've requirement like the following, I've a key field,if the value of key fileds are same for more than one record then we should check the date1 & date2 of both records,if the date1 value of the second record is one day greater than date2 of first record then both these records are merged t...
- Tue Mar 10, 2009 3:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sending Mail
- Replies: 2
- Views: 1446
Sending Mail
I'm creating a reject file in a job,If there are any records present in the reject file,i should send a mail to a appropriate DL. Current Approach: I was populating a new coumn with default value as '1' & populating the aggregation of the particular default column in another file & then read...