DSXchange

I am able to load data from oracle to snowflake using the "Snowflake internal location" option in the snowflake connector but not when using the External location(S3) option. job design is simple oracle stage >>>>>transformer>>>>>snowflake connector stage When using the internal location o...

Thanks for your responses guys but this is a strange problem To answer your question Chulett, Every file will either have a CRLF or just LF. But we can't predict which file will have which line delimiter. The issue is that when we had these jobs running in AIX environment, the sequential file stage,...

Hi We just migrated our datastage installation from AIX to LINUX and we have run into an issue with the sequential file stage. The sequential file stage is used to read a file and store the fields in an oracle table. The sequential file is reading files that may have CRLF or just LF as record delimi...

Hello,

Has anyone connected to cloudera hadoop cluster (connection type impala) using datastage? If yes, How?

I've tried ODBC, but it doesn't seem to be working? Any suggestion would be welcomed.

Hello, I'm trying to connect to cloudera hadoop cluster's table using a parallel job and ODBC stage. I'm getting below error: ODBC_Connector_6: ODBC function "SQLConnect" reported: SQLSTATE = 08S01: Native Error Code = 0: Msg = [IBM(DataDirect OEM)][ODBC Impala Wire Protocol driver]Socket ...

Hi We just recently upgraded to 11.3 on AIX. This is a clean fresh installation. We have one particular job which consist of a script that loads multiple input files in a loop until all are loaded. In each loop iteration this script does the following - 1. Calls an oracle stored proc. 2. Sends a res...

Chulett - Hi ! Can you please elaborate on that with examples ? Are you saying that there are string functions in server jobs that can be used for mathematical operations of the kind i mentioned in my original post ?

Thanks QT_KY. That is precisely what has been happening with us. Overflow and data corruption all over the place. Which is what prompted me to ask this question.

Does anyone know of any options if one needs to use these functions on larger datatypes ?

Hi Functions like MAX, MIN, CEIL, FLOOR etc work on INT32 datatype. What if my variables are larger than int32 ? For example, the signature for MAX is number1 (int32),number2(int32) returns int32 What if the values i need to compare are int64 ? or even Double. Are there no functions for larger data ...

I have two DataStage installations, one on AIX and one on LINUX, displaying the below described behavior. DataStage version - 11.3 .2 AIX version - 7100-03-03-1415 Linux version - 2.6.32-504.30.3.el6.x86_64 Problem description - ------------------------ I have two variables var1 integer var2 double ...

qt_ky - thank you ...i think that explains it.

I will mark this thread as resolved.

Yes sir !

I noticed it too.

But what does that signify. Why is it happening only on AIX ?
Why is LINUX putting out 111 ?

What can we try to fix this behavior ? Is there anything bigger than double that we can use ?

Is double restricted to signed 32 bit in datastage ?

Something weird is happening and i can't tell why. I send in two values in a comma separated sequential file - 9999999999, 111 (that is ten 9s) All columns and the stage variable in the job are defined as double 20,5. In the transformer i set a stage variable V = max(val1, val2) Then i output the st...

Ray I use dsjob -Server command where server - qxdstage5:9445 Do I need to use a different command line when using a server with a port ? Currently I am getting the below error where despite the 9445 port i specify in my dsjob command it still goes looking for 9443 for some reason. ERROR: Failed to ...

Thanks Ray ....now what do i have to do for the dsjob -server command to consider the port I am specifying in the environment variable DS_SERVER=qxdstage5:9445 ?

Why does it look for 9443 ?