Search found 221 matches
- Thu Mar 13, 2008 8:46 am
- Forum: General
- Topic: Problem reading XML in XML-Input
- Replies: 6
- Views: 2486
- Thu Mar 13, 2008 8:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DateTime using RowGenerator gives incorrect output
- Replies: 15
- Views: 4856
Ray/Group, The final/closure email from IBM Support is as follows. this issue has been raised with engineering before and i have attached your reuqest to a know ecase that we had riased with engineering. Currently they have said there are no plans for a imdediate fix as this is only a debug/devlopme...
- Wed Mar 12, 2008 9:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DateTime using RowGenerator gives incorrect output
- Replies: 15
- Views: 4856
Hi ArndW, Thanks for the followup. I had submitted this to IBM and this is what they came up with... this is a known issue but response from development has been that this is a debug tool and if you require you own date values to be entered then you will need to do this outside of the row generator....
- Wed Mar 12, 2008 9:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DateTime using RowGenerator gives incorrect output
- Replies: 15
- Views: 4856
Hi ArndW, Thanks for the followup. I had submitted this to IBM and this is what they came up with... this is a known issue but response from development has been that this is a debug tool and if you require you own date values to be entered then you will need to do this outside of the row generator....
- Tue Mar 11, 2008 11:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Troubleshooting unresponsive server
- Replies: 7
- Views: 1942
- Tue Mar 11, 2008 11:42 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DateTime using RowGenerator gives incorrect output
- Replies: 15
- Views: 4856
DateTime using RowGenerator gives incorrect output
I have a simple job as follows ROW Generator ==> PEEK. The Row Generator has 3 columns Name, ID and CallDate. Number of records is set to 1 Name is defined as Varchar(50) and extended properties link it to a job parameter ID is defined as Integer and the value is via job parametr. CallDate is Date C...
- Mon Mar 10, 2008 9:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Troubleshooting unresponsive server
- Replies: 7
- Views: 1942
- Sun Mar 09, 2008 11:39 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Troubleshooting unresponsive server
- Replies: 7
- Views: 1942
Troubleshooting unresponsive server
Our datastage server has stopped responding to client connections. When i attempt to connect to the server it hangs on the login screen forever and ever..... This is a GRID server that is fairly new (just development projects/jobs). I can telnet/ssh to the head node and other nodes in the grid. I ca...
- Sun Mar 09, 2008 11:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Print Filenames from Seq File using FilePattern
- Replies: 6
- Views: 6658
- Fri Mar 07, 2008 10:20 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Standalone Stored procedure stage execution
- Replies: 7
- Views: 3219
As craig opined, it is not possible to have the Stored Procedure Stage on a job canvas by itself. For now, I will leave the Row Generator linked to the STP. As for the matching column name, the Row Generator or some sort of input link needs to supply the column name that can be mapped to the Stored ...
- Fri Mar 07, 2008 12:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Standalone Stored procedure stage execution
- Replies: 7
- Views: 3219
Craig, Thanks for the followup and your time. Is there any overhead in using the Row Generator to route the param values to the job or should i look into using transformer for such purposes? lstsaur, Thanks for your time. I am afraid i am not following your feedback point(s) especially line 1 of you...
- Fri Mar 07, 2008 12:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Standalone Stored procedure stage execution
- Replies: 7
- Views: 3219
Craig, Thanks for the followup and your time. Is there any overhead in using the Row Generator to route the param values to the job or should i look into using transformer for such purposes? lstsaur, Thanks for your time. I am afraid i am not following your feedback point(s) especially line 1 of you...
- Fri Mar 07, 2008 12:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Print Filenames from Seq File using FilePattern
- Replies: 6
- Views: 6658
Ray, Thanks for the input. I tried this job without RCP and had the same outcome. I then tried the NON-RCP design in a 7.5.2 box and could not get the file names either. So something is wrong in the way i have set the stage. The only changes i have done to the source seq file stage after dragging th...
- Thu Mar 06, 2008 3:57 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Standalone Stored procedure stage execution
- Replies: 7
- Views: 3219
Standalone Stored procedure stage execution
Hi, I have a need to execute a MS SQL 2005 stored procedure from a datastage PX job and pass 4 parameters to this stored procedure via job parameters. I created a new PX job and added one "Stored Procedure" Stage to it and set it up as "Transform" type. I was able to configure th...
- Thu Mar 06, 2008 2:57 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML input.............
- Replies: 3
- Views: 1717
Hi Pavans, If you could provide some additional details, as Ernie requested, it would be of great help for others to help you. I ran into this error today when i was trying to parse an input xml file but had no repitition element defined. XML_Input_41,0: Error: No repetition element specified for li...