DSXchange

We are getting source data in EBCDIC and packed decimals format and we want to convert the incoming EBCDIC data to ASCII. Can anyone please tell, how can this be done?

Hi All,

Can anyone tell me where the tuning information of an hash file is stored after the hash file is tuned. Is it stored in the Dictionary? or anywhere else? Our requirement is to delete hash files and at the same time not loose their tuning information.

thanks,
meda

Hi folks, I'm trying to create an xml. What i'm doing is getting data from an oracle table and trying to create an xml. I'm able to create the xml, but, for some reason, the first column is missing in the xml. i.e., if i have 8 columns defined in the table definitions, i'm getting only 7 in the xml...

Hi folks, I'm trying to create an xml. What i'm doing is getting data from an oracle table and trying to create an xml. I'm able to create the xml, but, for some reason, the first column is missing in the xml. i.e., if i have 8 columns defined in the table definitions, i'm getting only 7 in the xml ...

Hi Ray,

I'm trying to use the after job subroutine present in the "General" Tab under the "Job properties" for a simple server job.

Thanks.

Hey Folks, Can anyone help me!!!!!!!!!! I'm getting the following warning when i'm trying to send mail using th DSSendMail After-Job subroutine. " JobCont..AfterJob (DSSendMail): The following tokens in the 'dssendmail_template.txt' file have not been set in the call to DSSendMail: %from%,%to% ...

Read the messages carefully - they tell you precisely what the problem is. You've set the null value property to "" (length zero), which is its default value, but you've specified the data type as string[11] so that DataStage is demanding that your null value be an eleven character string...

Hi Guys, Can anyone throw some light on to why am i getting such type of a warning message, the first message is : " LcWarehouse3Loans.SqWare3Arm: When checking operator: When validating export schema: At field "TRADE_DESK_AUTH_PRICE_PCT": "null_field" length (0) must match ...

hi all, My job's being aborted as i'm getting the following error "DSIN: Error when checking operator: When binding output schema variable "outRec": When binding output interface field "SSN" to field "SSN": Implicit conversion; from source type "decimal[9,0]&q...

Hi all,

Can anyone tell me, if there is any other option from where we could turn ON the 'Enable Runtime Column Generation' option.
I know that we can do this from DataStage Administrator, I just wanna know if there is another way of doing this?

Thank You,
meda.

ray.wurlod wrote:Open the table definition in Manager.
Select the Layout tab.
Choose the Parallel option.
Copy the schema, paste into any text editor.
Save schema file.

Thanks a lot ray, i got that.
kiran

Hi, Can anyone, please tell how can i generate a Schema file ? I have a requirement where, there are like 19 sequential stages in a job, using the same meta data, so i know tht instead of specifying the column definitions for each and every stage i can use a Schema file instead, but, i just dont kno...

Pls let me know more about your circustance, If the situtuation is as.... input is sequential file with delimited data, its obvious that, whatever the case be, varchar holds good for all the case. it can be integer or even special character(excepts the feild delimter or record delimter). Pls also p...

kumar_s wrote:Hi,
If you are reading it from sequential file, why cant you read it as varchar or decimal as required???

regards
kumar

Hi kumar,

how shall i read the field with date type. its giving me errors.

thanks
kiran

From where did you import the table definition? Hi Ray, The header in .csv file was not in a single line, so i had to copy the header to a .txt file and brought everything in one line, then only I was able to imort the table definitions. So, in this process i lost the actuall data types for the fie...