DSXchange

Ya but it was not working even if that is not expilictly mentioned as Not NULL. I just tried trail and error on the schema file. By default the coulmn are not null in the schema file. Can u please suggest on how to procedd to handle not nulls using Schema files. Is there any environment variable to ...

ArndW, Thanks for replying!! Following is the error message that i am getting Column_Import_1: In schema file "/local/apps/DRS_dstage/sandpit/tmp/dev/gdm2/ods/Sample_Schema1.schema": In field "SITE_NAME": Unknown schema type: not. I am using this schema file only for reading. Tha...

Hi, I have a generic parallel job that reads a schema file and loads in to target Database. I have a requirement of rejecting the rows if the value for a not null couln is NULL. Here is my Schema file record {final_delim=end, record_delim='\n', delim=',', null_field="", quote=double} ( SIT...

Yes, I tried this with peek stage and everything and data which hits the database is also very ok. It's not for a single record instead for all the records. not even single record is getting inserted into database. For every record it's throwing the same error nearly 20,000 in number. And there are ...

We went through most of the scenarios over Database related stuff. There is no new column is added, no datatypes were modified and whole database schema is untouched with modifications. we are getting the error as: countsODSLoadActType.xfm: ORA-01400: cannot insert NULL into ("ODS"."A...

Hello ... I have DS Job which is failing with error message as 'ORA-01400: cannot insert NULL into' from last 3 days. This Seems to be a strange behaviour to me because the job is already in production from last 1 year and I am getting the above said error even though there are no Null values in the...

Hello Experts, My Query seems very silly but I have a little confusion around functions Num & Isvalid(Decimal'[36,18]',stringData) . Isvalid(Decimal'[36,18]',stringData) is not actually Validating the Data coming with Space in it. If incoming Data includes any spaces in it, it will treat it as a...

Ernie, I am listing some of the combinations of the file that are expected. 1. <?xml version="1.0" encoding="utf-8"?> <Ext SDt="2009-03-08T00:00:00" EDt="2009-03-09T23:59:59" V="1"> <Site Cr="A1" St="ABCD"> <Bat ID="B-090108-...

Ernie, what you have thought is right. We do have deeper definitions for Stability and QC. These QC & Stability entities will hold their own subentities& attributes in them & that too will be in again hierarchical nature. It's true that,They are mutually exclusive in nature so we may end...

Ernie, We have given the site Xpath as the repetition element. But we are not even getting any nulls within the stability data . Basically the QC and the stability are at the same level QC would have "/Ext/Site/@QC" and Stability would have "/Ext/Site/@Stability" How do we get th...

Hi,

I am getting a tag in xml file that contains following data.

<Operator>&lt=;</Operator>

My seting for the colmn are Varchar. But iam getting the data in database as &lt=;

Actually the data amp; is missing.

Could anyone help in resolving the issue..it could be a great help

I have updated the services file with a valid entry on DataStage Server long back...

sapgw00 3300/tcp // check whether you are talking about the same entry.

I haven't found dsr3.pdf file anywhere, Can you please guide me from where can I get it?? or if possible post the relevent content here.

1) I had forwarded the ZDSRFC.txt and ZDSRFCU.txt files to SAP basis team. In those files I found 'Z_RFC_DS_SERVICE' function module only. They had created that function module but still getting the same errors. 2) Parallely I had created a new job which is using RFC Data Transfer method; I am getti...

ray.wurlod wrote:Is the service name ("sapgw00") correct? The error message suggests that it can not be found. ...

service name ("sapgw00") is correct and having a valid entry in services file... plz give me some tips how to resolve this problem...

Check also that you have indeed selected a BASIC Transformer stage rather than a parallel Transformer stage. ... Thanks all, Thanks for the inputs........i am able to use my routines in Basic Transformer stage of Parallel jobs....... As ray mentioned the problem is with the condition i incorporated...