Search found 43 matches

by kumar_j
Wed Jul 11, 2007 5:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Regarding DATE.TAG function
Replies: 6
Views: 3207

DSJobStartDate ,

by using this macro,
by kumar_j
Wed Jul 11, 2007 4:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Regarding DATE.TAG function
Replies: 6
Views: 3207

U should have the BASIC Transformer(parallel jobs) to work on it,

In server job ,we have the Build-in functions.
by kumar_j
Tue Jul 10, 2007 5:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: BATCH file to delete DATASETS
Replies: 7
Views: 3860

Re: BATCH file to delete DATASETS

But u need to save the dataset file name with .ds ext.

It has the control file inside it
G SHIVARANJANI wrote:Hi,

could u please tell me how to use the dataset file....

is that used the same way as a sequential file....in parallel datastage..




thanku..
by kumar_j
Tue Jun 19, 2007 8:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Notification_Activity_1
Replies: 1
Views: 1822

Notification_Activity_1

Hi all, When i try to use the email notification i am getting the following error, Can u please tel me where exactly we need to configure to work on it Thanks in advance ------- seq..JobControl (DSSendMail): Error when executing command: C:\Ascential\DataStage\Projects\Project\sendmail_seq.bat *** O...
by kumar_j
Wed May 02, 2007 1:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Type of System
Replies: 4
Views: 2075

Type of System

Hi gurus,
.I want to Information about my AIX Server ,is it SMP or MPP System
I am unable to see the Basic Tx in my server.Is there any AIX command to chk for SMP or MPP
by kumar_j
Wed May 02, 2007 1:27 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Teradata Stages
Replies: 2
Views: 1651

Teradata Stages

Hi Gurus, .I want to Extract and load teradata data by using the Data stage job, so please suggest Which stages are preferable in terms of performance point of view. I think Teradata Load and Multi load stages are available in parallel jobs.Is there any other stages (like plug-in's) to access terada...
by kumar_j
Wed May 02, 2007 1:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Teradata Stages
Replies: 4
Views: 2058

Teradata Stages

Hi Gurus, .I want to access and load teradata data by using the Data stage job, so please suggest Which stages are preferable in terms of performance point of view. I think Teradata Enterprise and Multi load stages are available in parallel jobs.Is there any other stages (like plug-in's) to access t...
by kumar_j
Fri Dec 29, 2006 5:12 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: IP change
Replies: 6
Views: 4114

IP change

Hi team,

.If there is Change in IP Address, what impact it will effect for our datastage server.I am using Server jobs .If required where to be changed



thks
by kumar_j
Wed Dec 27, 2006 5:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Execute Command
Replies: 3
Views: 1865

Execute Command

Hi Team, .I want to delete some data before running some set of jobs . I am trying to use the Execute Command in job sequencer to delete those data.I am using DB2 Database and i wrote the script which connects the database and some delete statements.When i try to run this job, i am getting the follo...
by kumar_j
Thu Oct 26, 2006 1:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Email Notification
Replies: 2
Views: 1752

Email Notification

hi all, I am using Email Notification Activity in my Job Sequencer .When i execute the job i am getting the following error. Could u please explain the reason behind this error. JobControl (DSSendMail): Error when executing command: filepath/sendmail_Email44232_8674_229476.sh *** Output from command...
by kumar_j
Tue Oct 24, 2006 4:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Execute Command
Replies: 5
Views: 2403

Execute Command

hi all, I want to execute one file which contains the connection command to database and some list of refresh Commands in DB2 Can any one please suggest how to use the Execute Command Stage in Job Sequencer as i want to call that file in that stage. so it will connect to db2 and execute those statem...
by kumar_j
Thu Aug 03, 2006 12:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: .odbc.ini
Replies: 6
Views: 4028

.odbc.ini

hi all, I want some clarification regarding the .odbc.ini file, which exists in $DSHOME/ under this folder . I found this in unix machine , when i try to see in my client windows machine i am unable to see the file where can i find the .odbc.ini file in client windows machine , this is hidden file a...
by kumar_j
Tue Jul 18, 2006 5:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Design Time
Replies: 4
Views: 3047

Design Time

Hi all.
When i try to open one job, i am getting the error like

This item has no design time information

But this job is running thru Director
Can any one explain what can be the Reason


thks
by kumar_j
Mon Jul 17, 2006 5:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to Schedule
Replies: 9
Views: 3522

hi all, when i try to schedule the job through dierctor , i am getting the the following error Error adding to schedule: at: 0481-166 The auditproc function failed with errno 1. (Command was: at -s 19:00 today ) (Data was: /eisetl/Ascential/DataStage/Projects/EIS_MOBILITY/dsr_sched.sh /eisetl/Ascent...