DSXchange

Here is the output for $OSH_PRINT_SCHEMA main_program: Schemas: Data set "ODBC_Connector_0:DSLink2.v": record ( BICOD: string[max=10]; BIBKC: string[max=10]; BIBTN: string[max=10]; BIANO: string[max=10]; BICUR: string[max=10]; BITRN: string[max=10]; BIAMT: string[max=10]; BICHQ: string[max...

Hi Craig,

I have mentioned my job design in my previous comment. Please let me know what more details you need in order to get more details about issue.

Hi Mike, Below is my job design: ODBC Stage ---> Copy Stage ---> Peek Stage 1) There is no metadata defined in ODBC connector. 2) My Select SQL statement has CAST function. I am converting all columns to VARCHAR using cast function. The column for which I am getting this error is of Numeric Type. 3)...

Yeah I tried using Environment variable $OSH_PRINT_SCHEMAS, but still I am getting the error. It has not resolved my issue.

Hi, I am facing the below error while reading the data from source using ODBC Connector. In source table all columns are NOT NULL and I am reading the table using RCP. While executing Its giving below error: Fatal Error: Attempt to setIsNull() on the accessor interfacing to non-nullable field Can an...

Hi pieterh54,

Please suggest, if you are able to resolve the issue or not. I am also getting the same issue.

There was some configurations settings needs to be done from Hive Administration. After that, its working fine now.

Below function is working fine. Using this I can load the String data from source to target having Double datatype in Hive.

<ColName>:DFLOAT=<ColName>

yeah. It will be a same job which needs to be run with different Value File at every Iteration.

To resolve the issue, I have created the file with the values of value file set and reading it using execute command stage and then passing the required value to loop .

Can someone help with the above error which I am getting while opening Datastage jobs because of which I am loosing Link details in datastage job. This happens very frequently and I have to rework on the code every time. Even if I take backup of code, below error keeps on coming after importing the ...

I have a parameter set having 6 parameters and 20 value file set. I need to run the job in sequence 20 times with different value file name each time. I have created a delimited list of value file names as below: ValueFileName1,ValuefileName2,ValueFileName3.... and so on... Now I wanted to pass Valu...

Hi,

My Source and target is Hive Database. I need to convert a column datatype from String to Double. I am using Run Time Column Propagation.

Using Modify stage is it possible to convert a Column from String to Double?

Hi,

Is there any way to execute a Multi Instance job in parallel for all the parameters (reading from a file) using looping in sequencer? And using only one Job Activity within Start and End Loop.

Or if there is any other way apart from looping in sequencer.

Hi,

Is there any document or website where I can find step by step configuration setting which is required to use File connector to read from Hive?

Ok thanks... Marking this post as resolved...