Search found 66 matches
- Tue Feb 25, 2014 2:16 am
- Forum: General
- Topic: pass environment variable in value file of parameter set
- Replies: 1
- Views: 1239
pass environment variable in value file of parameter set
Hello, We have a scenario where same job is used to load two database tables in different environment (for disaster recovery). We have used parameter set & have created parameter value file to achieve this. For now we are passing $PROJDEF for SYSA & hardcoded values for SYSB parameter. Param...
- Tue Jul 16, 2013 4:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Loading French character to Teradata 13.10
- Replies: 1
- Views: 3268
Loading French character to Teradata 13.10
Hello, We have received source file having French character. Our job is a simple job Read File => Transform => Load Teradata We have used NLS at Job level as ASCL_ISO8859-1. In Teradata connector we have used client character set as UTF-8. When I run the job, French character data gets processed suc...
- Wed Jul 13, 2011 12:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: LATIN1_0A Character set (Teradata) to UTF8 (Oracle)
- Replies: 1
- Views: 2165
LATIN1_0A Character set (Teradata) to UTF8 (Oracle)
Hello Experts, Need your help. We have a requirement to process data which contains German character from Teradata to Oracle Teradata (API/Enterprise) ---> Transformer -------> Oracle Enterprise NLS (AMERICAN_AMERICA.WE8ISO8859P1) NLS (UTF8) (ASCL_ISO8859-1) While running the process Source system i...
- Tue Jan 18, 2011 10:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Teradata API Satge - Error - Access Logging step has failed
- Replies: 0
- Views: 2136
Teradata API Satge - Error - Access Logging step has failed
I need help. One of Our Production started failing recently for issue - Access logging step has failed. This job reads data from Teradata Staging table we do some transformation after that we upsert data to four different tables. These four tables are all reference tables (Dimensions). For all four ...
- Wed Jan 06, 2010 11:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: load data from web page
- Replies: 0
- Views: 1006
load data from web page
Hi we have a requirement where we need to load data from web page (ex google spreadsheet or Currency exchange example
http://www.bloomberg.com/markets/currencies/fxc.html
)
will you please help if there is a way to load these data automatically through some job/script.
Thanks,
Bhaskar
http://www.bloomberg.com/markets/currencies/fxc.html
)
will you please help if there is a way to load these data automatically through some job/script.
Thanks,
Bhaskar
- Sun Dec 06, 2009 11:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Timeout reached before MultiLoad opened
- Replies: 1
- Views: 1680
Timeout reached before MultiLoad opened
Hi, I have a job which fails regularly on weekend, but its running fine over weekdays. ODBC => Transformer => TD Mload We have two target table stage on Output. Though there are no rows to fetch Job is running for 25 min & fails with above error. Please help if we need to set some parameter at a...
- Tue May 19, 2009 2:32 am
- Forum: IBM QualityStage
- Topic: QualityStage Desigr:Error:LoadLocalizedResource: The Resoure
- Replies: 2
- Views: 2093
- Tue May 19, 2009 2:31 am
- Forum: IBM QualityStage
- Topic: LoadLocalizedResource
- Replies: 4
- Views: 3089
- Tue May 19, 2009 2:29 am
- Forum: IBM QualityStage
- Topic: LoadLocalizedResource:The resource file was not found
- Replies: 3
- Views: 2137
No Ray, Where can i create the profile. What is the use of Datastage xpsp2 patch Have you been able to get as far as creating a profile? Is there any else to this message, or any other message? Do you have the DataStage xpsp2 patch installed? ... Hi, Basically the issue is because you do not have p...
- Wed Dec 12, 2007 1:13 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: TeraUtils:Fetch failed: Error Code = 227 [terautils.C:2863]
- Replies: 4
- Views: 4577
TeraUtils:Fetch failed: Error Code = 227 [terautils.C:2863]
Hi All, I am unable to read data from database using Teradata Enerprise stage the error which I am getting is TeraUtils:Fetch failed: Error Code = 227 [terautils.C:2863] DBCAREA msg_txt: MTDP: EM_CHARNAME(227): invalid character set name specified. [terautils.C:2864] <Stage Name>: APT_TeraUtils::con...
- Wed Sep 12, 2007 4:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Timeout while inserting data through Teradata Multiload stag
- Replies: 0
- Views: 1331
Timeout while inserting data through Teradata Multiload stag
Hi, I have a job which reads data from a staging table (Odbc stage) & loads the data to target Teradata table (Teradata Multiload). ODBC-(Source)-->Transformer-->Teradata Multiload(Target) In target stage we have delete in before sql & update in after sql. These delete & update are on th...
- Wed Apr 04, 2007 10:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Teradata Multiload stage Failure
- Replies: 3
- Views: 2827
Teradata Multiload stage Failure
Hi, I have a job which loads a table by using Teradata mulload stage. My job looks like ODBC stage--> Surrogate key Gen--> Transformer---> Teradata Multiload I am getting following error while running the job. <Link_name>,0: Failure during execution of operator logic. <Link_name>,0: Fatal Error: Fat...
- Wed Mar 28, 2007 3:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to connect to local Database
- Replies: 1
- Views: 2244
Unable to connect to local Database
Hi, We have Datastage V 7.5.2 installed on Windows. We are able to run job with file stage. We have created a local Teradata data base, We are able to login to this database. But we are not able to connect to this DB through Teradata API stage. The error which we are getting is "Unable to conne...
- Fri Dec 22, 2006 2:41 am
- Forum: General
- Topic: Schedule datastage job using command line
- Replies: 5
- Views: 9779
You can create a sequence as required then you can run this sequence, by using dsjob utility. Once you enter the command with dsjob in a script. you can make a crontab entry to schedule this script. Alternate way is just create a simple job (flat file) to (flat file), then call this script in this j...
- Fri Sep 15, 2006 7:37 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Problem with Aggregator
- Replies: 1
- Views: 1487
Problem with Aggregator
Hi, My Job design is (Source (DB2 table) with some lookup) ---> Agreegator ---> Target (DB2 table). I am facing problem while aggregating the record. Approximately I have 2.5 lacs record in Souce table. While running the job I get following Error mesg [IBM][CLI Driver][DB2/AIX64] SQL0912N The maximu...