How do i timestamp a file in DS?
Thanks
Search found 192 matches
- Tue Apr 21, 2009 2:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to timestamp a file
- Replies: 3
- Views: 2459
- Tue Nov 11, 2008 12:15 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: OPEN/CLOSE command for sqlserver Stored procedure
- Replies: 1
- Views: 1862
OPEN/CLOSE command for sqlserver Stored procedure
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 ...
- Wed Nov 05, 2008 1:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: 2 calls to Oracle function in PX
- Replies: 9
- Views: 4805
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...
- Wed Nov 05, 2008 12:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: 2 calls to Oracle function in PX
- Replies: 9
- Views: 4805
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...
- Wed Nov 05, 2008 10:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: 2 calls to Oracle function in PX
- Replies: 9
- Views: 4805
- Wed Nov 05, 2008 9:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: 2 calls to Oracle function in PX
- Replies: 9
- Views: 4805
- Tue Nov 04, 2008 4:06 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: 2 calls to Oracle function in PX
- Replies: 9
- Views: 4805
2 calls to Oracle function in PX
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...
- Tue Nov 04, 2008 10:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle enterprise stage Upsert not running efficiently
- Replies: 1
- Views: 1980
Oracle enterprise stage Upsert not running efficiently
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...
- Thu Oct 30, 2008 4:13 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sorting and writing to Oracle Enterprise stage
- Replies: 1
- Views: 1948
Sorting and writing to Oracle Enterprise stage
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...
- Thu Oct 30, 2008 6:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataStage vs stored procedure(partitioned)
- Replies: 0
- Views: 1738
DataStage vs stored procedure(partitioned)
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 ...
- Mon Oct 06, 2008 11:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle connectivity and imp table def in IS
- Replies: 6
- Views: 4143
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...
- Mon Oct 06, 2008 9:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle connectivity and imp table def in IS
- Replies: 6
- Views: 4143
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...
- Fri Oct 03, 2008 2:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle connectivity and imp table def in IS
- Replies: 6
- Views: 4143
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...
- Fri Oct 03, 2008 9:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle connectivity and imp table def in IS
- Replies: 6
- Views: 4143
Oracle connectivity and imp table def in IS
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...
- Thu Sep 18, 2008 11:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need to export jobs
- Replies: 2
- Views: 2428
Need to export jobs
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.
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.