DSXchange

How do i timestamp a file in DS?
Thanks

Im currently using an ODBC stage to connect to a sql server database. I need to execute a stored procedure in the same stage. I tried the OPEN/CLOSE command offered in the ODBC stage and getting errors like. [IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver][UDB DB2 for iSeries and AS/400]ILLEGAL ...

whoops! stuck one last time.. I'm using the below in a ORA Ent stage using a sparse lookup. I know in transformer stage we can use a system variable @PARTITIONNUM. How could I use that system variable in my ORA functional query call before. 1. select FNC_UTL_logfilestart(@PARTITIONNUM,sysdate,'Loadi...

Cool! So that would mean once the PARTITIONNUM is passed. Manufacture a record only for the first partition number. Partition numbers usually begin with 0. If 2 partitions then 0,1;if 4 then 0,1,2,3. So I would manufacture a record only for PARTITIONNUM= 0. Does that make sense or is that too static...

Nice suggestions! When we use a oracle function call and join it using a sparse lookup it is by default set to "Sequential mode". Now, if it is set to "sequential mode" how is it creating 2 records for my functionality. My default apt config files has 2 nodes running. So, going f...

This doesn't seem right since when we insert we don't expect it to duplicate a record. Similarly, any client would expect one function call from the Oracle Enterprise Stage to the function. There should be some way to control this. Thanks!

I have a function call to oracle using a sparse lookup. The function creates an entry in an "audit trail" table with batch_id and all that info and returns the batch_id. My default config.apt has 2 nodes. So every time the function gets called it is creating 2 entries for a batch_id in the...

I currently have a job writing data from sql server to oracle10g. I'm using Oracle Enterprise stage and selected the option "Upsert" and "Update then Insert". With that combination the data takes forever to get loaded with speed of 3 rows/sec. When I changed the option to "I...

1. I first have source data in an ODBC stage coming from Sql Server. 2. I then transform the data in a transformer stage. 3. Then I use a Sort stage. I need sort by Date_Id. Im using a hash partition and selecting perform sort ..this makes it show as Date_Id (performing and sorting) in the SORT stag...

Requirement - Only one record needed for a lookup. Debating the advantage of datastage over stored procedures..datastage calls all the rows into the memory(in lookup or a join) vs a stored procedure that makes a variable call from a cursor limting to say only one required row. So how does datastage ...

I think to connect through ODBC for tables def we will need to establish ODBC connection params in the files odbc.ini and uvodbc.config files. This means you would be beating the concept of native connectivity. Any native connection should use full thrust of its optimization by avoiding an extra lay...

To connect to Oracle there are two ways - 1. OCI stage 2. Oracle Enterprise stage. Let us consider Oracle Enterprise Stage. I understand this stage as native connectivity stage. This means that you don't have to use import from ODBC for table definitions. In that case, the question again reverts bac...

No I mean loading from the database. Yes you can hit load in the columns tab but that expects you to have pre-loaded metadata. My question more is related to, how do load table defs(metadata) into the table defs repository in Information Server/DS8. Do I need to use import functionality and ODBC tab...

1. I need to connect to Oracle through Enterprise stage. I understand once connections are established, I will need to go the Oracle Enterprise stage and go to DB options and enter user and password. Now, this should enable me to connect to Oracle through native connectivity right? 2. Now once I'm a...

IBM IS 8.
I need to migrate from test to prod. The only option I see to export ds jobs when I click on export is -"Export jobs without executables". Is there a way for me to export only executable SO I DONT COMPILE ALL JOBS in prod.
Thank you.