DSXchange

Thanks for the response Paul, I have a situation where the jobs have been designed in such a way that the data is being loaded in a insert into xxx select * from mode. I want to make this to run in multiple sessions as i believe this is invoking only a single session. I want to know if there is way ...

Hi, When trying to load data into a teradata table using bulk mode option with load type "Load",i am getting an error as "Properties /Usage/BulkAccess/LoadType, /Usage/WriteMode: Incompatible property values[Input link 0]". When I am selecting the Load type as Mload it is giving ...

Hi All, We have Information Server 9.1 release. I want to know if we can attach information server to a Filemaker Pro system as a data source?? Below URL has information about making Filemaker Pro system application as a datasource.Any ideas/thoughts would greatly appreciated. http://www.filemaker.c...

Can't we read the datasets which are ftp'd from one environment to other environment using Orchadmin command..?

Thanks
NJ

Hi,

These are the NLS charactersets that are being used by different versions.

For version 10.2 : WE8ISO8859P1(NLS_CHARACTERSET)

For Version 11.2 : AL32UTF8 (NLS_CHARACTERSET)

Thanks
NJ

Thanks for the responses. But, when i tried to connect to other oracle database instance(version 10.2)using plug-in metadata option it is importing it with the correct length. But, when i tried to connect to an oracle instance(version 11.2) with plug-in metadata option, Its giving incorrect length. ...

So, is it an issue with version 8.7 or with any version..? because we didn't have this issue in version 8.1. Thanks!!

Hi Chulett,

I imported using orchestrate method and it imported with the right length. But why its giving wrong length when trying to import with plugin metadata method. what would be NLS issue and how can we fix this. thanks!!

Thanks
NJ

Hi, When I am trying to import the metadata from the oracle table, the varchar field lengths are increasing by four times when compared to length in the actual oracle table. Version of datastage used 8.7 unix running on 4 nodes(so i doubt that its multiplying the length by 4..but dont know why) impo...

Hi, I have a scenario where the message is being posted from the mainframe to MQ and the message is in EBCDIC format. While I am trying to read the message from MQ using MQ connector stage it is showing me the format as "MQSTR". I am trying to read the message as Longvarchar.I tried to con...

Hi Bob, Your solution is working for the requirement that i mentioned in the post, thanks for that, but i forgot to mention complete solution that I am looking. Below is how i want the output to be eg: 1) james alex 1234 usa 2) johnny beck abc 1234 canada output (1)should be: 1)usa 2)canada output(2...

I believe count gives a number as output and i don't understand how doing a -1 on it will give the last string. please let me know if i missed anything.

Thanks
NJ

Hi All, I have a requirement where I have to capture the string from a line after a space in the reverse order. eg: 1) james alex 1234 usa 2) johnny beck abc 1234 canada output should be: 1)usa 2)canada note: The number of spaces are not constant. I tried to use the index function by mentioning the ...

Hi all, I have a unix shell script which checks the count of stored procedure error from a text file and if there is any error my unix script returns a value greater than 0(Using word count)and then using execute command stage to check if the trigger >0 i am stopping the sequence job. Now the requir...

I have tab delimited source file from that i am getting the date column in the format "dd-mon-yy" or "d-mon-yy" but, i need to load into oracle table with the default format. Plz help me how to achieve this.