DSXchange

Hi, I am getting the below warning while extracting data from sql db, for this i had enabled RCP. Please let me know whether it is related to data issue or i have to change any setting in my job. Please find the below warning for reference. Warning: main_program: Invalid character(s) ([xC0]) found c...

thank you, now i have an idea to proceed further.

i will get back to you for any issues, once again thanks a lot....

Hi,

if i am wrong please excuse, i understand that we can parameterize the query, but how do we go for metadata parameterization.
what i mean here is, as metadata is unique for each table and how do we download the metadata dynamically at run time.

Regards,
Dinesh

Hi, We have a requirement like to have a generic job that handles taking data from a source ( here it is sql db) at run time. Here my question is whether is there any possibility to define metadata at run time, i mean to have a single job which can be used to extract data from different tables havin...

ray.wurlod wrote:What database?

For example, if it's DB2, you can call the stored procedure through DB2 Connect. ...

It is a DB2 database only ray. But I need to capture the output parameters and load to a Oracle DB

How to invoke a mainframe stored procedure.
Actually there are no input parameters. This SP is run on a staging table.
there is one return code and 20 output parameters.

Hi,

Can you please guide us in handling to execute Mainframe shadow program using datastage.
As I have no idea in proceeding with mainfram integrated with datastage, Please let us know the procedure in what way we have to follow.

Thanks

Can you please let us know whether it is possible for installing different datastage server (7.5,7.5.2) in a single unix box with out over writing.

chulett wrote:Are you certain you've got a valid / working stored procedure? Tested it outside of DataStage? ...

It is a valid working one and it returns a result set in the Query Analyzer.

[quote="chulett"]Warning? What warning?[/quote The warning is " CopyOfTEST_SP..Transformer_20.Ref_data: DSD.BCIPut call to SQLExecute failed. SQL statement:{call IntlHeadCount.dbo.sp_user_scope_ifeed(?)} SQLSTATE=24000, DBMS.CODE=0 [DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Se...

We are getting warning while accessing a stored procedure, which takes a single parameter from a sequential file and returns a result set of 3 columns. we need to know how to pass parameter value by taking from a file to the ODBC stage to trigger SP and capture the result set in a file.

If there is no transformation, you can use schema files. But your requirement appears quite vague. Why use datastage to just pick a few columns? I cannot see any step before or after this activity. Actually there is no transformation. It is almost like filtering out few different columns everyday.

Sainath.Srinivasan wrote:Can do.

How do you intend to find which columns are required in output?

they will place the input file and the output file layout (i.e) the column names required that day in the same path

As per my requirement, both the input and output file layouts are dynamic for example if 100 columns are there in the input and 50 columns are wanted in the output today, Tomorrow there may be 120 columns in the input and 70 columns in the output. Can we incorporate this in datastage? **Note - subje...

When writing data to Hash files it is treating the below values as one and over writing the data.

256785A
256785a

Is there a solution to it as they are distinct values for me.