Search found 116 matches
- Wed Apr 13, 2016 1:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SQL Server connetion time out error
- Replies: 1
- Views: 2532
SQL Server connetion time out error
Hi , We are loadind data using odbc connector stage to load data to SQL server in multiple jobs however very frequenlty we are receiving below error and which leads failing the load cycle. Can some one help to fix this issue.I also contacted my DBA team but they are not very sure about this error. v...
- Sun Nov 23, 2014 8:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Variable length key is too large (32981) ,limit is 32767
- Replies: 2
- Views: 3785
- Sun Nov 23, 2014 9:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Variable length key is too large (32981) ,limit is 32767
- Replies: 2
- Views: 3785
Variable length key is too large (32981) ,limit is 32767
Hi , I am trying to write data from xml output column data into single field(longvarchar) in sequential file but I am getting this error "Variable length key is too large (32981) ,limit is 32767" I tried with increasing APT_DEFAULT_BLOCK_SIZE but didn't work , please help me to get this is...
- Mon Jun 04, 2012 7:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Decimal representation as Double datatype in xml stage
- Replies: 4
- Views: 3176
- Wed May 30, 2012 11:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Decimal representation as Double datatype in xml stage
- Replies: 4
- Views: 3176
Decimal representation as Double datatype in xml stage
Hi ,
I have a source field as decimal data type value is 899.00 but in xml stage datatype is double and value represented in xml as 899 my client expecting as 899.00 with double datatype Is this possible with out changing double data tyepe in xml ? please advise
I have a source field as decimal data type value is 899.00 but in xml stage datatype is double and value represented in xml as 899 my client expecting as 899.00 with double datatype Is this possible with out changing double data tyepe in xml ? please advise
- Wed Feb 29, 2012 1:33 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: call oracle stored procedure in datastage server job
- Replies: 8
- Views: 7330
- Mon Nov 22, 2010 4:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: HOW TO FIND CHINEES CHARECTER
- Replies: 1
- Views: 2641
HOW TO FIND CHINEES CHARECTER
Hi ,
is there any function to find chines character in a string? other than UTF-8,UNICODE just i need a function to find china character
i am getting china characters in my string so i need to find which one is china character .
is there any function to find chines character in a string? other than UTF-8,UNICODE just i need a function to find china character
i am getting china characters in my string so i need to find which one is china character .
- Tue Dec 08, 2009 8:02 am
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: xml read
- Replies: 3
- Views: 3487
xml read
Hi I am unable to split into columns from xml document.this is the format i am getting <identifier itemkey="0000056G8120">CARDPOP- STACKER DRIVER CARD</identifier> <identifier itemkey="0000056G8127">DRIVE ASM</identifier> <identifier itemkey="0000056G8151">CARDPOP STKRD...
- Wed Nov 18, 2009 6:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: vertical pivot
- Replies: 3
- Views: 3695
- Wed Nov 18, 2009 3:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: vertical pivot
- Replies: 3
- Views: 3695
vertical pivot
Hi
I knew vertical pivot is going to include with IS 8.1 ver but i am working on 8.1 i did not see any option for vertical pivot,could any one suggest me wether vertical pivot included in this release or not
Thanks
Thanks
I knew vertical pivot is going to include with IS 8.1 ver but i am working on 8.1 i did not see any option for vertical pivot,could any one suggest me wether vertical pivot included in this release or not
Thanks
Thanks
- Tue Jun 30, 2009 10:16 pm
- Forum: General
- Topic: Folder transfer from one server to another server windows
- Replies: 5
- Views: 3336
Folder transfer from one server to another server windows
Hi All,
Can any one help me on how to transfer a folder from datastage server to another windows server using DataStage.
Thank you very much in advance.
Can any one help me on how to transfer a folder from datastage server to another windows server using DataStage.
Thank you very much in advance.
- Thu Jun 11, 2009 12:20 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: SFTP with FTP stage version 8.1
- Replies: 8
- Views: 8424
Hi FTP stage works in server 8.1 but you will have to mention the file path as given ftp://160.61.16.2/\ETRAVEL.csv. SFTP does not work could not find as how to specify the private key generated by the SSH tool for windows. If any one have solution for SFTP on windows please let me know Thanks.........
- Mon Jun 01, 2009 12:29 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Zip a file
- Replies: 28
- Views: 13347
- Fri May 29, 2009 12:45 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Zip a file
- Replies: 28
- Views: 13347
- Thu May 28, 2009 11:34 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Zip a file
- Replies: 28
- Views: 13347