DSXchange

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...

yes,xml string contains larger than 32k

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...

xml input 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 think you can try before /after sql query tab in oracle stage in server
eg.call storeprocedurename ;

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 .

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...

Thanks a lot ray , i have attended corporate training for ISv8.0 in IBM that time fecilitator told me that

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

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.

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.........

yes,i ran from cmd but i am getting just blink screen while running this batch file ,nothing is asking


thanks

Thanks a lot chulett,
my batch file is located in D:\ so that i given after sobroutine D:\batchfile.bat but job is hanging any reason
should i try with "D:\batchfile.bat"?(quotes)
or any other reason?

Thanks

No chullet,
I did not understand what i need to do job is running long time i am no able to stop also.
I was set the path in environment variable there we have all path values .
still i am not able to resolve

any help Appreciable

Thanks