DSXchange

Hi chulett, thanks for the suggestion.
you mean \[ ] need to include to handle space?

can you please put the complete command

Thanks,
ureddy

Hi, I tried to replace a string with spaces in external filter stage with sed command. Its not giving the expected result. Looks im missing some thing in the sed command? Source: THE STATE CA THE STATE NY Output: CA NY So need to replace the THE STATE with the 9 spaces. Tried sed -e 's/THE STATE/ /g...

By mistake , I have marked , let me know , if there is a solution for this problem.

I have included this environmental variable , let me know , if there is any ideal solution for this problem.

Its basically the low values/junk /special characters which are causing the problem , is there any of handling those, so that I can load using bulk load option into Oracle

one more point to add to give clarity, using the Char() function, i am able to load into oracle , but there is no data for that particular column in Table. If IsNull(colname) Or colname = Space(80) Then Space(80) Else Char(colname) Please , let me know the right approach to deal with this conversion...

In Source mainframe the column is Char & the same in the target Oracle. In fact I have tried to resolve by using the CHAR () , but could not succeed . Actually , the baseline is there are some junk characters/special characters in data , which is causing the issue. I have changed few NLS setting...

I am encountering the below error in the load job(Dataset->Transformer->Oracle). Prior there is a extract job (CFF->Transfomer->Dataset). Actually error is occured , due to data issue , as its pulled from Mainframes , seems like there are low values (special charactes). Db_ODS_Acct_summary,8: A data...

If I understand your requirement correctly "if the source column is null then 1 else source column". Try the below expression

If IsNull(LNK_SRC.PARTY_NO) Then 1 Esle LNK_SRC.PARTY_NO

Regards,
Ureddy

Thanks Ray.
What are the ways the users can de-cataloged these sub-routines?
It can be done from Administratior or from UNIX server only we can do it?

Regards,
Ureddy

Hi All, While running the sequence jobs Iam getting the below error for all the sequence jobs and then the sequence job is getting aborted. "Attempting to Cleanup after ABORT raised in job test_uma.. JobControl" The error ia coming for all the sequence in the 'ABC' project on 'XYZ' server....

Its working after writing the query on one line. Thanks ArndW I cannot list all the dependent jobs from the master sequence,few jobs are not listing. Master_seq | JobA | JobB / \ JobC JobD | JobE Note: JobB to JobC and JobD Except JobD I am getting all the jobs in dependency list. I checked the JobD...

Hi All, I am trying to extract the job dependency list from sequence job by using the below query in universe stage, but i am getting the below error. Query: SELECT DS_JOBS.NAME, EVAL DS_JOBOBJECTS.'@RECORD<31>' FMT '32L' COL.HDG 'DEPENDENT_JOBS' FROM DS_JOBS, DS_JOBOBJECTS WHERE DS_JOBS.NAME = '<<S...

Hi Chulett/Ray,

Below function working fine and giving the only record count as output.

Field(Trim(Convert(@FM," ",Execute_Command_45.$CommandOutput))," ",1,1)

Thanks for everything.

Regards,
Ureddy

Hi,

Convert(@FM," ",Execute_Command_45.$CommandOutput) is giving the output as 20 /path/filename
but after applying the Field function its giving ""

Field(Convert(@FM," ",Execute_Command_45.$CommandOutput)," ",1,1)

Any suggestions?

Thanks,
Ureddy

Hi All, In execute command im checking the file count using UNIX command wc -l filename. The output from the command is below 20 filename Based on the file count i need to run the next jobs(Ex:If file count is 0 then run JOB1 else JOB2.) I need to fetch only filecount from the above unix command and...