DSXchange

kool78

Hi, How to execute a SQL server stored procedure for each row. The SP has two input parameters and one output parameter. I need to execute the SP for each row of my result set and generate an output result set. We are on 7.5.1a version and stored procedure stage doesnt allow to execute MSSQL stored ...

kool78

Has anyone seen the below issue before: when reading data from oracle stage , espceially when you hardcode a value and alias it to a column, the oracle stage is returing the data with spaces padded to the right side for example, in oracle stage in my query select 'TEST' as COL1 from dual (with colum...

kool78

Hi,

I'm using an XML Input stage to read the data from a URL.

Wanted to know if there is a limitation for the length of the URL string which is passed as an Input to the XML Input stage.

Thanks

kool78

Looks like they want you to access things strictly through their web services and direct access of the underlying database is... discouraged. Web Services Access SharePoint Database Access Craig, THanks for your input. From the link i saw a we serivce availabe in sharepoint 2007 i.e List Data Retri...

kool78

I tried to serach the forum on how to access the MOSS sharepoint data using datastage.

Currently we are on Datastage 7.5.1a version and we dont have web service package.

Is there any other method that i can utilize.

Any help is appreciated.

Thanks.

kool78

Heelo gurus,

is anyone familiar with , how to know the code behind the following DataStage builtin Macro 'DSHostname'

Appreciate any kind of information

Thanks

kool78

Is your requirement exactly to Just to Truncate or Truncate before the Next insert. If the its earliar, you could either opt for Stored Procedure or Series / Parallel Truncate statements in User defined sql in OCI stages. If second later is the case, you can choose, Truncate adn Insert option durin...

kool78

Hi, I have a scenario where in i have to truncate several tables(~25 tables) in a single job. What is the best way to do it 1) to make you of a single store procedure which truncates all the tables or 2) to build a single job which truncates all the tables (rowgen-oci stage with truncate load option...

kool78

ray.wurlod wrote:
kool78 wrote:can we omit the later part i,e' records' and allow it to display only the value like 1500.
Use the -n option of the dsrecords command.
Code: Select all
dsrecords -n /app/A ...[/quote]

thanks ray,

followed the dsrecords method,


dsrecords -n <datasetname>

kool78

umamahes wrote:dsrecords <datasetname>

Thanks

thanks for the response, seems to be working.. it displays the out put as ex: 1500 records

can we omit the later part i,e' records' and allow it to display only the value like 1500.

kool78

Any ideas on how to get eh count of number of records for a dataset. i tried to look for the 'orchadmin' commands but didnt find any help. thanks Manager/DataSet Management..... :P is there any other way...i know we can get the count from dataset manager/managment. i want to use it in my process..l...

kool78

Any ideas on how to get eh count of number of records for a dataset.

i tried to look for the 'orchadmin' commands but didnt find any help.

thanks

kool78

There's no project level setting for this, or at any level for that matter. What's different about this project - it's not Protected, is it? :? ... nope its not protected, it is a DEVL envionment. i tried to export the dsx of the XML table definition from a different project and imported back to th...

kool78

There's a new one. Strange how the Project is the cause, or has something wrong with it, especially for release 7+ where the XML Stages are just "there"..... Though I can't remember exactly when we started including them by default....in 7.0 they may have been installed separately. What r...

kool78

I was trying to import xml table definition, but was encountering the below error: No connection could be made because the target machine actively refused it Source : System Target Site : System.IO.Stream OpenRead(System.Uri) Win32/COM code: 0x0 at System.Net.WebClient.OpenRead(Uri address) at Syste...

DSXchange

Search found 102 matches

Stored Procedure issue

Oraclestage padded space issue

XML Input Stage URL string

How to access MOSS Sharepoint data using Datastage

Code behind Datastage Macro 'DSHostname'

Truncating several tables

Re: How to count he number of records in a dataset

How to count he number of records in a dataset

Problems in Importing XML table definition