Search found 1213 matches

by SURA
Thu Aug 11, 2016 8:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: need the output as of below in the datastage parallel job
Replies: 9
Views: 2855

Yes thats right!

This morning when i read the post, it looks like an SMS to the mate \ team member , not the request to get the solution.

Its not a good practice and i was waiting for the comments .

I totally agree.
by SURA
Thu Aug 11, 2016 7:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Real time Data using Datastage
Replies: 7
Views: 4511

Thanks Ernie for the immediate response. So far the information i am getting from you and Ray is so useful. In the Web Service Explorer I can see the service name as a root of the tree, then the port name and finally "Failed" message. I don't have the option to import all operations, or no...
by SURA
Thu Aug 11, 2016 7:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Real time Data using Datastage
Replies: 7
Views: 4511

Ray and Ernie Thank you so much for the guidance. I have managed to install a SOUPUI and imported the wsdl (Initial few wsdl wasn't able load using SOPAUI due to some issue in the wsdl) and i have managed to send the request and get back the response. When i try to import the same wsdl i got the bel...
by SURA
Wed Aug 10, 2016 10:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Real time Data using Datastage
Replies: 7
Views: 4511

Thanks Ray

I will try to do the way you suggest.
by SURA
Wed Aug 10, 2016 8:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Real time Data using Datastage
Replies: 7
Views: 4511

You are right. I am having challenges to make the web services working. When i try to import using wsdl i am getting the below errors. Warning Cannot resolve the 'schemaLocation' attribute. Error The MaxInclusive constraining facet is invalid - the string '+10000' is not a valid UInt16 value. Error ...
by SURA
Thu Jul 28, 2016 8:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Adding comma's to an amount field
Replies: 10
Views: 5564

The intention of my question is about the data and the validation around the data, if it is going to be other than numeric or decimal.

The solution (routine) is already in forum or while read SQL can do the same.
by SURA
Thu Jul 28, 2016 8:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Vertical Pivot
Replies: 6
Views: 4742

Noted.

Not by intention.
by SURA
Tue Jul 26, 2016 12:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Vertical Pivot
Replies: 6
Views: 4742

Re: Vertical Pivot

I think the code is working as expected. If you have master KEY values, then keep it in a table as a source and left out join the data table (present source) so that you can get the result as expected.

Correct me if i haven't paid enough attention!
by SURA
Mon Jul 25, 2016 11:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Adding comma's to an amount field
Replies: 10
Views: 5564

What is the target data type ?
by SURA
Mon Jul 25, 2016 10:23 pm
Forum: General
Topic: How to get yesterday date in job sequence
Replies: 5
Views: 4532

Re: How to get yesterday date in job sequence

I would use unix command

Code: Select all

date +%Y:%m:%d -d
by SURA
Sun Jul 24, 2016 11:04 pm
Forum: Site/Forum
Topic: Keep asking password while reply
Replies: 4
Views: 17867

Who is Online

In total there are 42 users online :: 0 Registered, 1 Hidden and 41 Guests

But i am in online
by SURA
Sun Jul 24, 2016 9:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle connector Stage - Delete vs Truncate
Replies: 5
Views: 5409

cdp wrote:No need to do both indeed.
I will go for the delete statement if there's no difference then :)
Truncate is efficient than delete.
by SURA
Sun Jul 24, 2016 7:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Record loaded issue
Replies: 6
Views: 4147

Re: Record loaded issue

It may be due to Auto commit off in the DB :lol:

Choose the option Auto commit On from the stage.
by SURA
Sun Jul 24, 2016 6:26 pm
Forum: Site/Forum
Topic: Keep asking password while reply
Replies: 4
Views: 17867

thanks

Let me try
by SURA
Sun Jul 24, 2016 6:06 pm
Forum: Site/Forum
Topic: Keep asking password while reply
Replies: 4
Views: 17867

Keep asking password while reply

Hello All

For the past 1 week, when i reply to any comments in the forum , it log out the session and asking the password again!

Need to retype everything.

Is it for me alone?