Search found 180 matches

by rafidwh
Thu Dec 15, 2005 9:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORA-00257
Replies: 1
Views: 1466

ORA-00257

WHEN IAM TRYING TO VIEW DATA IN TGHE OCI STAGE IAM GETTING THIS ERROR ORA-00257 (ARCHIEVE ERROR,CONNECT INTERNAL ONLY FREED)
PLEASE HELP ME OUT
:(
by rafidwh
Wed Dec 14, 2005 12:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: update,insert or delete
Replies: 1
Views: 1063

update,insert or delete

flatfile-----------oci(update) I -----------oci(insert) I I I trgoci(lkp) I have to update or insert based on two key columns,I did using the logic in the transformer Now the client has changed the functionality that the records should be "deleted" based on a timestamp,means he doesnt want...
by rafidwh
Mon Dec 12, 2005 3:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: updat or insert
Replies: 5
Views: 2218

I need to overwrite on the duplicate rows and insert new rows
by rafidwh
Mon Dec 12, 2005 3:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: updat or insert
Replies: 5
Views: 2218

iam using OCI stage,what condition should we put in the transformer stage,about the look up key columns
by rafidwh
Mon Dec 12, 2005 2:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: updat or insert
Replies: 5
Views: 2218

updat or insert

I need to update existing rows or insert rows based on two look up keys
can anyone tell me what the condition to be written in the constraint for both UPDATE AND INSERT
PL HELP ME OUT
THANKS
:(
by rafidwh
Mon Nov 21, 2005 2:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: filter records
Replies: 8
Views: 1741

filter records

i have a .dat file of some 150 positions in the first row of target,8-15 pos is date and in teh second row i have to pick 8-10 pos like c1 c2 c3 c4 1-2 3-5 6-9 10-16 c1 c2 c3 c4 c5 c6 1-2 3-6 7-10 11-17 18-20 21-24 how to define the metadata in the target columns,how to pick thenm from dat filewith ...
by rafidwh
Fri Oct 21, 2005 2:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: exit code 157
Replies: 5
Views: 2890

hey iam sorry arnd actually the errors is getting in the logfile
by rafidwh
Fri Oct 21, 2005 1:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: exit code 157
Replies: 5
Views: 2890

Hi arnd,i think you havent caught the question,
iam extracting a flat file but when i try to view the data using the path param,iam getting that error.

i think u got the question,and i hope so
:wink:
by rafidwh
Fri Oct 21, 2005 1:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: exit code 157
Replies: 5
Views: 2890

exit code 157

in the production environment iam getting an error exit code 157 what does it mean,where the error is >
pl help me out
by rafidwh
Fri Oct 21, 2005 12:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSD.SEQOpen Failed to open <file> in <dir>
Replies: 12
Views: 10860

DSD.SEQOpen Failed to open <file> in <dir>

i am using a sequential file as a source and when iam trying to view data iam getting this error message,but the same job with same parameters the onsite guys could able to view the data the error :MlkuexpReconBaseBEST..LoadBest.in1BbaExtract: DSD.SEQOpen Failed to open LoadBest.txt in directory /et...
by rafidwh
Thu Oct 13, 2005 9:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: code migration
Replies: 2
Views: 1591

code migration

'Code migration is done for all Datastage Programs, Unix scripts, and Autosys jobs.'
this is the message from my client,and the is datastage upgradation from 6.0 to 7.5 both working on different box.
now i want to know how we can migrate the unix scripts ,jobs etc
best suggestion plllllllllllll
by rafidwh
Thu Oct 13, 2005 5:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: upgradation
Replies: 2
Views: 1037

upgradation

i had a task for upgradation ,i just want to know what are all the steps i need to follow to upgrade from ds 6.0 to 7.5 on same platform.how to back up,and what are all the contents i need to back up.what sort of errors may rise and how to resolve them.best suggestion plllllllllllll
by rafidwh
Wed Oct 12, 2005 11:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: copy of jobs
Replies: 2
Views: 1080

copy of jobs

i have got some jobs which are in read only when i open them,and my clients asked to create a new job category and copy all the jobs in the new category and that will work,but atill i am able to open them in read only, best suggestion please
by rafidwh
Wed Oct 12, 2005 10:31 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: upgradation
Replies: 1
Views: 749

upgradation

what are the xternal utilities generally have in upgradation from Ds6.0 to 7.5
by rafidwh
Tue Oct 11, 2005 1:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: upgradation from 6 to 7.5
Replies: 3
Views: 1114

upgradation from 6 to 7.5

hi u was given task to upgrade jobs from DS 6.0 to 7.5,since i havent worked on it i want to know how the migration is done and what are all the factors to be considered while migrating,what type of errrors generally occurs and how to resolve them,if any screen shots that will be help ful
rafi