DSXchange

I have a requirement, where I need to read data from Sharepoint, did any one of you implemented it?

I tried Unix Curl command but the file is show in a different form then the actual Xls file

Let me know if you need any further inputs

Hello All, I am facing some strange prob when I run a SQL Server 2008 Query from Data stage Sequence. Some time it runs fine and some time's it runs with out any warning or error but says no rows effected. At times it says too many lines per statements Did any one of you come across these situations...

Source - Teradata Target - Seq File Bkgrnd - Job successfully executes when a Date field is used in where condition. However whenever I use a Timestamp(0) field in where condition it errors out. The where condition is passed through a parameter Tried all these : WHERE A.ORD_TS BETWEEN '2011-04-10 00...

Hello, Here is my query. When I run this in Teradata SQL Assistance I get the results. select count(*) from lci_loyal_views.sywr_enrollment_exclusions where TRS_DT >= '2010-12-01' and TRS_DT <= '2010-12-31' When I put the same query in datastage using a ODBC stage I am getting zero records. can some...

Hi,

Option 1: change data type from Date to Varchar
Option 2: At the project level change the Date format to include the Micro seconds

The other reason could be is some else is holding your parameter set while you are adding it

Or someone else is compiling the jobs before you have compiled with the new set of parameters.

Let us know if this is one of the reasons?

Hi,

The other option would be to force compile the job.

Hi,

Is that mandate to uninstall the IIS. If I understand it correctly then we are moving from DB2 to Oracle, so even if we don't do that, it should be fine.

Hi,

That is not possible in the job. Try creating a preprocessor job where you check for the anomalies in the file.

Hi,

If you are loading into a database then we can stop. But if your requirement is to abort the job while read from Sequential file, where the reject are more then 10%, then you have to do that before the job starts.

You can call that as a Preprocessing.

Hi,

Between any two passive stages we can add copy stage, to avoid segment failures.

Hi,

add 10,000 to the given value.....

Hello, I am seeing strange behavior of ODBC stage while accessing the SQL Server. When I use the following SQL Select A, B, C from <Table> It is hanging after fetching some 100 -1000 records (Running on a four node config) When I run the same job with the following SQL it run fine Select A, B, C fro...

Julio Rodriguez

Thanks for your input, I am talking to my sales person.

Hello, Our CASS Files expired this morning, and the job's started aborting saying that update file are not present. "CASS_Address,0: Quality Stage Compressed USPS data files are older than 105 days. New files must be obtained (USPS requires that no processing be allowed). error opening files fo...