DSXchange

I have tried below in transformer and got the expected results.
pwr( (1+(-2.0/100)),((1.0/12)-1))

convert the incoming columns to floats and this should resolve the issue.

Hi, We are running 11.3 version on Linux server. I have a requirement to call a RestFul Webservice from DataStage and download the data from client in JSON format. For security reasons, call should be made using POST method rather than GET. I tried to find documentation on using POST method to read ...

Thanks for the replies.

In the grand scheme of things to worry about, why this? I am going with 5.

Hi, I am running DataStage 8.7 on Linux environment. We use SQL Server for data purposes. Assuming SQL Server name is "SqlServ" which has 5 databases ( DB1, Db2, DB3, Db4, Db5) under it with multiple tables in each database. A datastage application id is created to read from all 5 database...

Hi,

We are running DataStage 8.7 on Linux server. There was a requirement to connect to Windows share space from Linux and access the file.
Windows share space ( vFiler ) is only a share space with no FTP running on it.
Is there a way to connect Linux to VFiler wiht no FTP?

Delete is part of Before SQL and inserts are part of SQL statement. Both are two different transactions. I am using ODBC stage.

Hi, I am running DataStage 8.7 on Linux environment. I have a requirement to extract data from Oracle and load into a table named "table1" in SQLServer. But before loading "table1" i am required to delete all the existing records and then insert the new ones. Tricky thing, is &qu...

Ignore this topic. Error was due to lack of execute grants on Oracle procedure.

Hi, I have an oracle store procedure named "dummy.sp_call" ( schema = dummy & procname = sp_call ). I am required to execute this from either Oracle connector or Store procedure stage. As a first step, i have used store procedure stage and provided the procedure name "dummy.sp_cal...

Thanks Ray.

Is there any other way i can get both Delete(Once) and Insert all in single transaction. Requirement is i am supposed to use ODBC stage only since we are migrating from oracle to sqlserver in near future.

Hi, I have a job like ODBC(ext)----->xfm-----ODBC(load). In ODBC load, i am required to delete the data in a table and after it is complete, load the contents coming from xfm into the same table. Deleting the contents of table and inserting into same table should be a part of single transaction. To ...

Hi, I did created a ODBC entry in .odbc.ini file and in uvodbc.config file to connect to Oracle DB "XXX". When i test it, i am getting "No Listener" error. My question, as i am connecting to oracle should i also have a TNS entry for Oracle DB "XXX". And also instead of ...

Hi, I have a requirement to 1) get the list of files from oracle database 2) get list of files from remote server by connecting using ftp 3) compare the files from remote ftp to files available in oracle and read the files which are unique to remote server. I am trying to connect to remote server vi...

In previous versions, there used to be a dropdown to select the parameter which is added as a string in SQL. But now if the select the parameter from right side of SQL, then whole SQL is replaced with parameter values. It worked when i just remembered the parameter and executed the query like select...

Hi, I am running DataStage 8.5 and i am required to pull data from DB2 DB and Oracle DB. I have used DB2 and Oracle connectors. I have query like select aa,bb,cc from t ( select aa,bb from table_name where month = pass_parametere and year = pass_parameter ) join ( select cc from table_name] where la...