Is there any way I can include check constraints in Schema file, to brief about this-
Say, if I am getting Data in any column as "N/A", then I have to drop that whole record and the same should not be imported from any source extract file.
Please suggest...
Search found 193 matches
- Tue Dec 07, 2010 11:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Check Constraint in Schema File
- Replies: 1
- Views: 1194
- Tue Dec 07, 2010 11:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Create xml files from flat files using schema file
- Replies: 11
- Views: 14618
- Fri Dec 03, 2010 5:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Field defaults Quotes In Sequential File stage
- Replies: 6
- Views: 3586
- Wed Jun 09, 2010 8:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dealing with XHTML Files
- Replies: 4
- Views: 2014
- Tue Jun 08, 2010 6:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dealing with XHTML Files
- Replies: 4
- Views: 2014
Dealing with XHTML Files
Hello All, Has anybody worked with XHTML data files. I was working with hierarchical XML before but the client has come out with XHTML stuff. i never worked on these before. So can anybody elaborate what would be the possible issues with XHTML comapred to XML. 1. I can see that the size of the XHTML...
- Wed May 26, 2010 9:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: 'Unit Of Work' commits?
- Replies: 6
- Views: 2814
In Server canvas, 'transaction grouping' comes into picture when the ORACLE stage(ODBC/OCI) receives multiple links from the same transformer stage. The problem with the PX job is that multiple processes are started, and there is no way for one process to rollback another process. For PX jobs you wi...
- Wed May 26, 2010 9:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem with XML job
- Replies: 34
- Views: 12703
- Fri May 21, 2010 3:38 am
- Forum: General
- Topic: Special character being ignored by Oracle Stage
- Replies: 4
- Views: 2508
- Tue May 18, 2010 8:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Adding Headers into Web Service
- Replies: 2
- Views: 1426
Thanks Ernie, I tried building the header with login details and the added specific hardcoded value (as it's SOAP over HTTPS) by creating the XML Response (using XML Output stage) and sending back to web service through Web Service Transformer. But didn't succeed to make it work. So It would be very...
- Mon May 17, 2010 8:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Adding Headers into Web Service
- Replies: 2
- Views: 1426
Adding Headers into Web Service
Can anybody elaborate on including the Header and passing on them to Web Service Transformer ? Actually I have two Input parameters UserId & Password through which I will be extracting Header details like 'ServerURL' and 'SessionId'. Now My query is, How to send these two parameters as Header af...
- Fri Oct 09, 2009 12:47 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Missing Record Delimiter as " " Issue
- Replies: 1
- Views: 2141
Missing Record Delimiter as " " Issue
Hello All, We are facing following error, when we execute/run through Script. Missing record delimiter " ", saw EOF instead In script we are actaully FTPing the data file & removing '^M' characters as well. But when Execute the same Datastage Job only for same Data file(after removal o...
- Fri Sep 25, 2009 7:11 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Rouitne to create the file in appending mode
- Replies: 3
- Views: 2395
- Fri Sep 25, 2009 6:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Validation Against XSD
- Replies: 15
- Views: 13551
- Wed Sep 16, 2009 6:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Validation Against XSD
- Replies: 15
- Views: 13551
- Wed Sep 16, 2009 5:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Validation Against XSD
- Replies: 15
- Views: 13551