DSXchange

Hi Bala, I have already created few jobs with sequential file as source and they are working. But for this xml file I am not able to figure out the problem. The source column name is DUMMY. Its datatype is Varchar and length 50000. I dont think so column name makes any difference in the job. Thanks ...

Hi, I imported metadata from the xml file using XML Meta Data Importer. The structure of my XML doc is: <?xml version="1.0" standalone="yes"?> <report> <table> <columns> <column name="campaignid"/> <column name="adgroupid"/> <column name="keywordid"/...

Hi, I searched DsXchange and could not find any solution, So writing this query. My Job structure is as below: Sequential File --> XML Input --> Dataset Job is able to read data from the sequential file but no records are getting loaded in to the target dataset. XML File Size: 4753 KB Able to view X...

Hi, I am getting the following error while trying to insert into DB2 table using DB2 Enterprise stage. Db2udb_SCR_TYPE_REAS: Unable to convert the adapter spec ostrstream object with a value of `' to ustring. The query in the Db2 stage is as follows: INSERT INTO TEDCDW.SCR_TYPE_REAS (SCR_TYPE_REAS_I...

The exact name of the environment variable is

$APT_STRING_PADCHAR.

Hi,

U can find the Fixed_Width option:

In Format tab, Right click Record Level --> Format as --> Fixed Width Record.

Thanks
Bandish

More info required on ur query:

For one CUST_NO can the number of records fetched from the reference table(table 2) vary.
I mean for CUST_NO 123 u get 2 matching records and for CUST_NO 456 u get 3 matching records.

Hi,

SQL-02127 Precompiler/SQLLIB version mismatch

Cause: The program was linked to an older version of SQLLIB, which is
incompatible with this release of the Oracle Precompilers.

Action: Relink the program with a newer version of SQLLIB

IHTH


Thanks
Bandish[/b]

Hi,

May be you can use

IsValid('DATE',StringToDate(<Column Name>,"%yyyy%mm%dd"))

It will give output as 1 or 0 depending on if the date is valid or not for the provided format.

Thanks
Bandish

Hi, As per my knowledge, this compile time error occurs when you use an environment variable in the derivation directly as $COB_DT. Instead the derivation should be GetEnvironment('COB_DT') , which will fetch the value of the Environment variable. If you have a Job parameter, you can directly mentio...

Hi, I need to know if there is any default value defined for a NOT NULL timestamp field when lookup fails. I get ************ when lookup fails for a Not Null Timestamp field. For example: For a NOT NULL integer field default value is 0 if lookup fails. Similarly, If we are fetching a NOT NULL times...