Search found 51 matches

by him121
Fri Sep 21, 2007 1:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Handling Auto Generated column values via RCP
Replies: 3
Views: 3211

Change Transformer property to run on a Sequential Mode.
by him121
Wed Jan 24, 2007 11:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Project Locked Error
Replies: 2
Views: 3765

Project Locked Error

Hi Experts we are getting Project locked error again and again. see the exact error: ACCESS DENIED: Project Currently locked The Project is currently locked by the Administrator. Try again later or see your administrator. Other projects on the same machine are working fine and they are not getting t...
by him121
Tue Dec 12, 2006 10:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Db2 Bulk Load (TEMP_FILE) Error
Replies: 9
Views: 11136

Db2 Bulk Load (TEMP_FILE) Error

Hi All I am getting below error... while loading Data through Db2 bulk load. I have alredy created TEMP_FILE into below path. I am not able to understand what is "/DB200002.PID/DB2" means? is it runtime temp file creation? If anyother setting needs to be done then give me the idea. Thanks...
by him121
Tue Dec 12, 2006 7:03 am
Forum: General
Topic: Db2 Bulk Load (TEMP_FILE) Error
Replies: 1
Views: 2838

Db2 Bulk Load (TEMP_FILE) Error

Hi All I am getting below error... while loading Data through Db2 bulk load. I have alredy created TEMP_FILE into below path. I am not able to understand what is "/DB200002.PID/DB2" means? is it runtime temp file creation? If anyother setting needs to be done then give me the idea. Thanks...
by him121
Tue Feb 21, 2006 10:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Loop in Transformer
Replies: 12
Views: 6572

Loop in Transformer

Hi All I am trying to convert one seq file let say SRC.txt to TGT.txt. SRC structure is Name Age Count AA 32 4 BB 21 2 TGT structure (No. of rows are depend upon the 'Count' Value) Name Age AA 32 AA 32 AA 32 AA 32 BB 21 BB 21 Can any one through some light how can i achieve this. I dont want to writ...
by him121
Mon Nov 07, 2005 8:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Wanna Import 7.5 Job into 7.1 Version?
Replies: 4
Views: 3097

Wanna Import 7.5 Job into 7.1 Version?

Hi..All

I developed few Sequence Jobs in ADS 7.5 Version
I want to trasfer it to ADS 7.1 Version
is it possible without developement??

Thanks
Him
by him121
Fri Oct 14, 2005 2:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: The performance of IPC stage
Replies: 2
Views: 2232

IPC Stage will use to allocate memory block while transfering data (rows) Block by Block between Active->Active or Active->Passive Stages.
this will give better performace to diff processes to read and write data.

Himanshu
by him121
Mon Aug 22, 2005 9:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Using hash files instead of UV tables for multirow
Replies: 13
Views: 19226

Thanks Huy for help.

But I used Universe stage ..with User difined query like
Select code from HASH where L_lmt <= input And U_lmt >= input;
and I did Lookup with UV Stage directly...
but here i needed to conver ..decimal values into Varchar...

Thanks...anyway
by him121
Sun Aug 21, 2005 10:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: HASH File question
Replies: 2
Views: 2526

HASH File question

Hi.. I want to read HASH file into Routine.. through TCL command line.. Problem is HASH file having Column name X and values are like 0.000236 when I fired command on DS Admin Command window,,, SELECT X FROM HASH; its giving me all the values...like 0.000000. can any one through some idea..how can i...
by him121
Sun Aug 21, 2005 10:50 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Range lookup
Replies: 6
Views: 3533

Range lookup

Hi All Need some urgent help Regarding Range Lookup.. I have in A table 3 column X,Y,z.. Values of X,Y,Z are like ("1A","0.000150",0.000200"") Now i want to do lookup with this table... when my input value is between Y and Z... it shd return me value of X... Means my qu...
by him121
Tue Aug 16, 2005 1:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Which Job is using Dataset?
Replies: 3
Views: 3025

Sorry by mistake i posted this question there too.. but anyway any answer for this question...as i am new to PX..and strugging here..to search for Dataset .... in diff jobs.. XML export i am doing and working with that.. but can anyone tell me ....whether any DS Admin Command is available for this.....
by him121
Thu Aug 11, 2005 1:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Which Job is using Dataset?
Replies: 3
Views: 3025

Which Job is using Dataset?

Hi All

If i know Dataset name can i get all the jobs which using this Dataset as inout or Output

something like Usage analsis for this..

Thanks
Himanshu
by him121
Wed Jun 15, 2005 1:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Need help to success in interview
Replies: 19
Views: 8282

Hi All It was very nice discussion goin on here i was just surfing forum and stopped at this question i am agree that experts in US are losing jobs or getting less pay & people in india are getting more jobs in ADS. but i will frankly tell you the quality of work which is coming here is not suit...
by him121
Fri May 06, 2005 6:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Peoplesoft EPM 8.8 & 8.9
Replies: 3
Views: 3224

Peoplesoft EPM 8.8 & 8.9

Hi All What is the future of Peoplesoft EPM 8.8 and EPM 8.9 after the Oracle takeover of Peoplesoft ?? I've heard that Oracle will be coming up with fusion architecture for the whole suite, so what would be the future of the ETL tool Ascential Datastage with the Oracle Fusion EPM product. Any Ideas ...
by him121
Thu Mar 24, 2005 5:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Phantom error
Replies: 3
Views: 2829

hey search this forum for how to solve the phantom error.
just go to &PH& directory and see the Process running file you might get some idea what exactly the error is.