Search found 13 matches
- Sat Aug 11, 2007 12:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Enterprise stage showing execution mode as sequential
- Replies: 1
- Views: 2103
Oracle Enterprise stage showing execution mode as sequential
Hi, I am using Oracle Enterprise stage in Datastage PX v7.5.1. The stage showing execution mode as sequential only while reading from the oracle 10g table. How can I make it to parallel as the execution method is set to sequential by default and not allowing me to change to parallel as it is disable...
- Tue Jun 12, 2007 6:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Enable orachadmin
- Replies: 4
- Views: 2526
Enable orachadmin
I am using Datastage 7.5.1 on AIX server. I need to delete .ds file using unix command.
When I give the command
orachmin delete $Path/xxx.ds
it gives me an error as "ksh: orchadmin: not found".
Can you help me out in enabling the Orchadmin?
Regards,
Tushar
When I give the command
orachmin delete $Path/xxx.ds
it gives me an error as "ksh: orchadmin: not found".
Can you help me out in enabling the Orchadmin?
Regards,
Tushar
- Sun May 07, 2006 11:23 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem while viewing DB2 stage
- Replies: 1
- Views: 1132
Problem while viewing DB2 stage
Hi All, I have Datastage 7.5.1 client installed on my machine. I am using UB2 as my source and hence using the DB2 enterprise stage to read the data. Earlier I was able to read the stage peoperly e.g setting up the parameter, changing the matadata etc. But suddenly it stopped working. Whenever I cli...
- Wed Sep 07, 2005 3:50 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: $Projdef
- Replies: 5
- Views: 7841
Re: $Projdef
Hi Pongal, $PROJDEF is a default value assigned in the job parameter of any Datastage job. Now consider the scenario where administrator wants to keep some password which should not be accessed by the developer. Then in this scenario administrator can set the password for Suppose DB login in a admin...
- Mon Aug 15, 2005 11:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Empty Data Set
- Replies: 3
- Views: 1988
Re: Empty Data Set
For clearing the existing data from dataset, set the Update policy as "Overwrite" and use row generator for creating the dataset with zero row.
- Sun Aug 14, 2005 11:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Eleminating first row in SQF
- Replies: 3
- Views: 1811
Re: Eleminating first row in SQF
In Sequential file stage you have a option where you can set the first the line as column header. So DS will send the remaining data to next stage. You do not need to use unix script or transformer.
Regadrs,
Tushar
Regadrs,
Tushar
- Fri Aug 12, 2005 3:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Runtime Error in transformer!!!!!
- Replies: 10
- Views: 4408
Re: Runtime Error in transformer!!!!!
check whether your C license expired? Also check the version of C is compatible with the DS version.
- Wed Aug 10, 2005 12:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sparse Lookup
- Replies: 4
- Views: 3471
Sparse Lookup
But if you use the sparse look up, then process will be slower as it has to hit the database for every record. But if you use the normal lookup then it will cache all the record and then do the look up.
- Mon Aug 08, 2005 3:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Substracting Days from a Date
- Replies: 5
- Views: 2791
Re: Substracting Days from a Date
Hi, You can use the built in function to convert the date into number of days and from that u subtract the required no of days. For that you can use some built in function available in PX, e.g. DaysSinceFromDate or JulianDayFromDate. Once subtraction is done then convert the result into date by usin...
- Wed Aug 03, 2005 12:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Finding Max of date
- Replies: 11
- Views: 5269
Finding Max of date
Hi, One approach is to Convert your date in the Integer format means if yor date is "yyyy-mm-dd" then convert it into "yyyymmdd" which is the integer and then use the max/min function. You can not aggregate on Date column as Aggregator stage converts into default dfloat before do...
- Wed Jul 27, 2005 3:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: date conversion
- Replies: 27
- Views: 10411
Re: date conversion
What is your output stage? If it is a sequential file then while writing in the file you can specify the format as "DD-MM-YYYY". But as far as datastage is concern it will always read the date in "YYYY-MM-DD" format. hello., i am new to datastage. my inut date format is : YYYY-MM...
- Wed Jul 27, 2005 2:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: compliation of job in command line
- Replies: 5
- Views: 2277
compliation of job in command line
I would also like to know how to compile the job through the Unix prompt. Multpile job complile option is anyway GUI. But if there is option to compile the job through the Unix then we can automate the process to compile the job from UNIX if required. regards, tushar Muliple job compile options is a...
- Sun Dec 19, 2004 1:01 am
- Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- Topic: Import and Export services in RTI
- Replies: 0
- Views: 2733
Import and Export services in RTI
Hi, We had register the job maps for one of the server. Our prject contains huge no of jobs. We want to run our jobs on other server. So we exported the Job maps from old server. Now we imported the export file in New server, but the jobs were not running. If we try to create new maps on the new ser...