PX does not have any native SAP 'plug-ins' that I know of. I do not have any experience in using PX with SAP.
Any DSX'ers with experience with SAP and PX?
- BP
Search found 180 matches
- Tue Mar 23, 2004 9:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Running SAP R/3 & BW with Paralell
- Replies: 2
- Views: 3143
- Tue Mar 23, 2004 9:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Odd connection errors: (also posted in the Datastage forum)
- Replies: 2
- Views: 3193
Odd connection errors: (also posted in the Datastage forum)
Seems like your connection is timing out. What is the maximum time you can connect without activity to your mainframe?
- BP
- BP
- Tue Mar 23, 2004 9:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Accidentally deleted the jobs.
- Replies: 6
- Views: 6322
Accidentally deleted the jobs.
Depends... Do you back up your PX server? You could possibly restore the RT_BP* files for the jobs off a backup.
If you don't back up the PX server or if you don't use version control with the PX GUI, you're going to have a hard time recovering deleted jobs.
- BP
If you don't back up the PX server or if you don't use version control with the PX GUI, you're going to have a hard time recovering deleted jobs.
- BP
- Tue Mar 23, 2004 9:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: broken while generating rows
- Replies: 1
- Views: 3094
broken while generating rows
Have you tried doing the same thing with a simple SQL script? This would isolate the issue to an Oracle error.
- BP
- BP
- Wed Mar 10, 2004 5:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: very simple:null represented as double quoted empty string
- Replies: 3
- Views: 3516
very simple:null represented as double quoted empty string
What is the problem you are having? Does PX not recognize the "" as a NULL?
- Wed Mar 10, 2004 5:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Development 7x and Production with Oracle Scripts
- Replies: 3
- Views: 4043
Development 7x and Production with Oracle Scripts
The upgrade from 6x to 7x shouldn't be a problem. Just import the 6x dsx file into 7x. As for moving from loading data using sqlldr vs. using PX, it is as Ray said. Write the data out to a flat file and then call the sqlldr script outside of PX and give the sqlldr command the name of the flat file y...
- Wed Mar 10, 2004 5:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Bring together 4 variable files into 1 file.
- Replies: 3
- Views: 3823
Bring together 4 variable files into 1 file.
You could add a record-type tag to each record and then just cat your files together on UNIX..
-BP
-BP
- Wed Mar 10, 2004 5:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Compressed Sequential File
- Replies: 2
- Views: 3317
Compressed Sequential File
No more 'filter' option in 7.0? That's not so good. I can't think of any way to do it besides gunzipping the data outside of the PX job...
If you end up asking the Ascential folks what to do and they give you a good answer, please post the solution here..
Thanks,
BP
If you end up asking the Ascential folks what to do and they give you a good answer, please post the solution here..
Thanks,
BP
- Wed Mar 10, 2004 5:28 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Basic Tranformer Error Message
- Replies: 4
- Views: 4524
Basic Tranformer Error Message
Rstone,
Did you resolve this issue? If so, what was the resolution?
Your descriptions of the Basic Transform in PX make it seem like the Basic Transform is buggy.. Care to comment?
Did you resolve this issue? If so, what was the resolution?
Your descriptions of the Basic Transform in PX make it seem like the Basic Transform is buggy.. Care to comment?
- Wed Mar 10, 2004 5:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Tranform runs too long!
- Replies: 5
- Views: 4982
Tranform runs too long!
I agree with Ray. If you are not able to solve the problem, could you post the generated basic code?
Thanks
BP
Thanks
BP
- Wed Mar 10, 2004 5:23 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Insert rows in more than one tables
- Replies: 8
- Views: 7369
Insert rows in more than one tables
You can execute a user-defined sql statement within some of the PX database stages. You could try executing all three inserts in the user-defined sql section and put a commit at the end.
If you're pushing a large amount of data, Peter Nolan's suggestion is a good idea.
- BP
If you're pushing a large amount of data, Peter Nolan's suggestion is a good idea.
- BP
- Mon Feb 23, 2004 1:38 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Removing SpecialCharacters
- Replies: 3
- Views: 2631
Removing SpecialCharacters
Or you can use the UNIX utility called sed. It is well documented on the web.
-BP
-BP
- Fri Feb 20, 2004 7:32 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Transformer Stage
- Replies: 3
- Views: 1907
Transformer Stage
This should be a fairly straightforward constraint.
For outputA, set the constraint to COLA > COLB. For outputB, set the constraints to NOT(COLA > COLB).
Is this what you are doing?
-BP
For outputA, set the constraint to COLA > COLB. For outputB, set the constraints to NOT(COLA > COLB).
Is this what you are doing?
-BP
- Fri Feb 20, 2004 7:25 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to overcome SAS Parallel Data Set Stage Constraints
- Replies: 2
- Views: 2803
How to overcome SAS Parallel Data Set Stage Constraints
.psds files are parallelized SAS datasets that have been "PX"d. You can't use them with native SAS, only with PX. If you do not want a parallel dataset, write the output of the stage to the Sequential File stage and create the dataset as a regular UNIX file.
-BP
-BP
- Fri Feb 20, 2004 7:17 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: row count in dataset
- Replies: 3
- Views: 2656
row count in dataset
Do OUTROWNUM and INROWNUM work in PX's transform? If so, that would be the way to get a row count. For a total record count of a dataset, use a 'dsrecords'.