Search found 30 matches

by vasam
Sun Mar 06, 2011 4:58 pm
Forum: General
Topic: Sechduling job through autosys on every Tuesday
Replies: 3
Views: 3520

Sechduling job through autosys on every Tuesday

Hi All,

I have a scenario like i want to schedule my autosys jobs every Tuesday of week and 29 th june ..If 29th of june comes on Tuesday, i want to run my job only one time.How can i schedule my jobs through autosys?

Thanks in Advance
Vijay
by vasam
Mon Jan 24, 2011 8:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Teradata connector issue in Production
Replies: 3
Views: 5696

Thanks for sharing information..

I have checked with my DBA's.. they have not installed properly in prod
by vasam
Sun Jan 23, 2011 5:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Teradata connector issue in Production
Replies: 3
Views: 5696

Teradata connector issue in Production

Hi All, I'm using Teradata connector stage to extract the data..i am using Bulk option. My job is running fine in DEV and SIT environments,,But job has failed in PROD environement... i am getting below error in Production. [IIS-CONN-TERA-005004] RDBMS code 21012: Could Not Find Message Catalog operm...
by vasam
Tue Jan 11, 2011 5:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Teradata connector Sync timeout of 20 seconds
Replies: 2
Views: 6360

Teradata connector Sync timeout of 20 seconds

Hi all, I am Teradata connector stage to extract , my volume of data around 15,00,000 it is extracting fine up to 14,00,000 . after that i getting below error Sync timeout of 20 seconds expired while waiting for the other instances to reach state 11 (CC_TeraAdapter::waitForState, file CC_TeraAdapter...
by vasam
Fri Oct 29, 2010 7:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ColumnImport stage error unidentified error
Replies: 1
Views: 1396

ColumnImport stage error unidentified error

Hi All, I have a scenario like i have to funnel two source links, one link having 10 columns, second link having 3 columns so what i am doing is in my second link to add rest ofthe columns i used columnimport stage their i have mentioned Import input column = Dummy and i created some nuew columns . ...
by vasam
Thu Oct 28, 2010 9:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error when checking operator: Could not find input field
Replies: 4
Views: 8859

Error when checking operator: Could not find input field

Hi All, when i am using modify stage i am facing below error Error when checking operator: Could not find input field "pdct_num" Actuallly what i done is in modify stage i want to give a some default value ot one output columns, so i edit the columns tab their i selected defaultvalue optio...
by vasam
Thu Oct 28, 2010 6:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Is it possible to add colums in modify stage?
Replies: 1
Views: 2081

Is it possible to add colums in modify stage?

Hi All,

Is it possible add columns in modify stage? if yes ,i want to assign those column to setnull. and one more thing is it possible to give default values like (99999) for output columns whiver newly added in modify stage?


Thanks,
Vijay
by vasam
Mon Sep 20, 2010 1:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: String to decimal conversion problem
Replies: 2
Views: 2384

String to decimal conversion problem

Hi
I have source varchar(255) value 123456789123456789 , i am trying to converting this varchar to decimal (18.2) , but i am unble to converting.

I am getting output like all zeros.(0000000000000000.00 )

Any suggessions
Thanks in advance
by vasam
Wed Sep 15, 2010 4:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date type conversion
Replies: 3
Views: 2355

Date type conversion

How do i convert date 2010-May-12 to 12-05-10?

I am using Parallel extender.

Any suggesion pls?
by vasam
Tue Jun 29, 2010 7:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to reset the job if any job fails in project ?
Replies: 10
Views: 5629

Thanks for your reply,

Actually my req is i am not going to touch any job in the projects, what ever jobs available in particular project which are abot staus i want to Reset the job. I may use this job different project also.

Thanks,
Vijay
by vasam
Tue Jun 29, 2010 6:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to reset the job if any job fails in project ?
Replies: 10
Views: 5629

Thanks for ur reply,

can you please provide code if you have, that would be very helpful for me.

Thanks,
Vijay
by vasam
Tue Jun 29, 2010 5:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to reset the job if any job fails in project ?
Replies: 10
Views: 5629

How to reset the job if any job fails in project ?

Hi All,

I have a requirement like i want to reset the job if any job fails during the execution(system crash etc) in entire project?

my reqirement is

if any distaer happens my jobs are in abort status, so i want to reset all the jobs at a time?

Any idea?

thanks,
Vijay
by vasam
Wed Jun 09, 2010 6:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: wrapper stage failing
Replies: 5
Views: 2840

Thanks for your reply,

ls.op file is exist in /opt/IBM/InformationServer/Server/Projects/CBMDR_PRT/wrapped directory.

Eventhough its giving error.

Thanks,
Vijay
by vasam
Wed Jun 09, 2010 6:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: wrapper stage failing
Replies: 5
Views: 2840

wrapper stage failing

Hi All, In my job we are using wrapper stage to listout all the files in particular directory. when i am executing my job i am getting below error. Wrapper printed bad property list: Expected "{", got: <eof>, line 2; stdout text: ##E IIS-DSEE-TOSH-00385 21:55:38(039) <main_program> Exec(ls...
by vasam
Wed May 12, 2010 11:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Differene between export with executables and without ?
Replies: 4
Views: 3078

Differene between export with executables and without ?

Hi

What is the difference between Export with executables and with out executables?