本文总结了DataStage在处理与Oracle配合时遇到的各类问题，包括DSsmtp邮件模板、随机错误、日期问题、Oracle连接问题、Sequence File Stage空值处理、去除回车符、后台查询JOB列表、环境变量使用、数据转换函数IConv和OConv等，并提供了详细的解决方案和操作步骤。
导读：DSsmtp:[210.75.71.180]dssendmail_template.txt*OnUNIXtorunsendmail,thetemplatelookslikethis(doesn'trequireasection):#!/bin/sh/usr/lib/sendmail-t<///From:%from%To
DSsmtp:[210.75.71.180]
dssendmail_template.txt
* On UNIX to run sendmail, the template looks like this (doesn't require a section): #! /bin/sh
/usr/lib/sendmail -t <///
From: %from%
To: %to%
Subject: %subject%
Server: %server%
%body%
3.23 随机错误问题
DataStage Sequence程序随机错误，错误是找不到/tmp目录下的该JOB的临时文件，重新编译后正常Run,错误描述:
I_Tr_EDS_TM_DOL_BRAND.#0.CNTR_WEdsTmDolBrandLdf_ins.LK05-Input.LK01:
ds_ipcopen() - Error in open(/tmp/ade.SGMEDW.I_Tr_EDS_TM_DOL_BRAND.#0.CNTR_WEdsTmDolBrandLdf_ins.LK05-Input) - No such file or directory
最低0.47元/天 解锁文章
扫一扫
1369
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
