DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 67 matches
Author Message
 Topic: Special characters in Test - How to handle in datastage
Naren12345babu

Replies: 1
Views: 255

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Aug 11, 2017 12:35 pm   Subject: Special characters in Test - How to handle in datastage
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi All,

I am moving an XML content from SQL server table to a file.

In my XML content , I have (') , and Control Z characters.

datastage is not able to read these values , it writes the fil ...
 Topic: Unix Script to Connect to SQL Server
Naren12345babu

Replies: 6
Views: 685

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue May 02, 2017 1:42 pm   Subject: Unix Script to Connect to SQL Server
Hi Chulette, the post was posted by me only, I am trying to find a way to load xml data into a single column., I am exploring a way thorugh datastage and another way through unix.

do you know how t ...
 Topic: Unix Script to Connect to SQL Server
Naren12345babu

Replies: 6
Views: 685

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue May 02, 2017 12:35 am   Subject: Unix Script to Connect to SQL Server
Hi

I have to insert XML content present in a file into an XML column in SQL server table. through datastage, I am not able to insert complete XML into single column.
SO , I want to use a Bulk ins ...
 Topic: Unix Script to Connect to SQL Server
Naren12345babu

Replies: 6
Views: 685

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon May 01, 2017 2:22 pm   Subject: Unix Script to Connect to SQL Server
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi All,

Any idea how to write a script to connect to SQL server from unix?

thanks
Naren
 Topic: Inserting XML into SQL Server table XML column
Naren12345babu

Replies: 3
Views: 587

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon May 01, 2017 2:21 pm   Subject: Inserting XML into SQL Server table XML column
hi. i can get full XML file when I write to disk. the problem is with ODBC Connector stage.
 Topic: Inserting XML into SQL Server table XML column
Naren12345babu

Replies: 3
Views: 587

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Apr 28, 2017 2:42 am   Subject: Inserting XML into SQL Server table XML column
DataStage® Release: 11x
Job Type: Server
OS: Unix
HI All,

I am trying to insert an XML content into XML Column datatype in SQL Server table. But I am able to insert only half of the XML.

I am using ODBC Connector stage to insert XML content.
...
 Topic: Extracting View from DataStudio vs Datastage
Naren12345babu

Replies: 1
Views: 432

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Feb 03, 2017 2:39 am   Subject: Extracting View from DataStudio vs Datastage
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi All,

I am trying to extract data from a view.
When I extract the data using SELECT COL1,COL2,COL3 from ViewName in IBM DataStudio, I am getting all records. Lets say 40000

When I use the sa ...
 Topic: Webservices client stage - Fatal error
Naren12345babu

Replies: 2
Views: 466

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sat Dec 17, 2016 1:47 pm   Subject: Webservices client stage - Fatal error
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi All,

I am using Webservices client stage. My job is failing with the below error:

WSDL_WebService,0: Fatal Error: Fatal: 0026`:`com.ascentialsoftware.wsclient.ServiceInvocationException: Serv ...
 Topic: Error using - XQUERY in ODBC Connector stage
Naren12345babu

Replies: 5
Views: 1571

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Nov 01, 2016 11:31 pm   Subject: Error using - XQUERY in ODBC Connector stage
Hi

I have removed Set commands from the query and put it in Before SQL, Now again I am getting below error which I got when I did not use SET commands at all.

ODBC_PAYLOAD_QUUE_ITD,0: ODBC func ...
 Topic: Error using - XQUERY in ODBC Connector stage
Naren12345babu

Replies: 5
Views: 1571

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Nov 01, 2016 3:03 pm   Subject: Error using - XQUERY in ODBC Connector stage
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi

I am using an XQUERY to extract XML Data in SQL Server table. I have used certain SET options as well. I am getting error while viewing data through ODBC Stage. I am calling Select statement th ...
 Topic: Unix Folder access in Prodcution
Naren12345babu

Replies: 2
Views: 521

PostForum: General   Posted: Thu Jul 28, 2016 9:13 am   Subject: Unix Folder access in Prodcution
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi,I recently deployed code to production. In production we have created few folders such as Inbound, Reject.

When we run datastage jobs in Production we are getting Permission denied error for th ...
 Topic: Sequential File --> All Records are coming in a single re
Naren12345babu

Replies: 4
Views: 876

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue May 10, 2016 4:06 pm   Subject: Sequential File --> All Records are coming in a single re
I am Seeing this output in Windows.
 Topic: Sequential File --> All Records are coming in a single re
Naren12345babu

Replies: 4
Views: 876

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue May 10, 2016 3:18 pm   Subject: Sequential File --> All Records are coming in a single re
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi,

I have my source as

AD
TPR
DISPLAY

When I am writing this to sequential File, I am getting output as

AD TPR DISPLAY

The Sequential File Format settings are Final Delimiter = Whi ...
 Topic: RCP not found in Parallel Job
Naren12345babu

Replies: 2
Views: 612

PostForum: General   Posted: Mon May 09, 2016 12:33 pm   Subject: RCP not found in Parallel Job
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi ,

Although I have enabled Run-Time Column Propagation in Administrator, I am not able to find the option for RCP in Job Properties of the job. Can anyone tell me what the issue is and how to res ...
 Topic: DSSendEmail in Before/After SubRoutine
Naren12345babu

Replies: 1
Views: 709

PostForum: General   Posted: Thu May 05, 2016 3:55 am   Subject: DSSendEmail in Before/After SubRoutine
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi,

I need to call DSSendMail routine in Before Subroutine of a job.

what is the syntax i need to provide in Input Value ?
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours