Top "Datastage" questions

DataStage is the ETL (Extract, Transform, Load) component of the IBM InfoSphere Information Server suite.

How to remove leading zeros in DataStage

I am trying to remove the leading zeros in the decimal field in a sequential file stage. what is the …

datastage
SQLState 02000 No row was found for FETCH, UPDATE, or DELETE

I'm running jobs through Datastage with the DELETE then INSERT connector. I'm having several jobs failing for this error: DB2_…

db2 datastage
Dumping dataset (.ds) file contents to a text file

At work we use DataStage which uses dataset (.ds) files. I can view the contents of the file from without …

unix dataset datastage
How to transform a string into timestamp in DataStage?

I read data from a csv file,and I get a string like "2010-7-3", I can't transform this data …

datastage
'SQL1024N A database connection does not exist. SQLSTATE=08003' error while executing 'db2 -x' command through command stage in Datastage 9.1

I'm getting 'SQL1024N A database connection does not exist. SQLSTATE=08003' error, while executing 'db2 -x' command through execute …

data-warehouse datastage
Where are the C++ compiler folders LIB and INCLUDE located?

I'm trying to set C++ compiler for IBM DataStage ETL tool. I installed Microsoft Visual C++ 2008 Redistributable (x64) for my …

c windows windows-server-2008-r2 datastage
How to add one day in date in datastage server

How to add one day in VDate column where column VDate value is not fixed. Example: input VDate = "2013-02-07" …

datastage
Job parameters in IBM datastage job

IBM datastage is a new tool for me and I'm unable to find any good pictorial and step by step …

parameters jobs datastage