Skip to content

Commit f624af8

Browse files
committed
Update NOTE and IMPORTANT quotes to be multi-line
1 parent 28d16a5 commit f624af8

7 files changed

Lines changed: 15 additions & 9 deletions

File tree

docs/ssma/db2/messages/db22ss0573.md

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -70,4 +70,5 @@ GO
7070
CREATE UNIQUE INDEX [CUST_CID_XMLIDX] ON [SAMPLE].[CUSTOMER] ([INFO$CID])
7171
```
7272

73-
>[!IMPORTANT] Adding an extra column to the table (computed column in this case) will affect all `SELECT *` queries. Make sure your application explicitly lists all columns in the `SELECT` statements or disregards any extra columns that might be returned.
73+
> [!IMPORTANT]
74+
> Adding an extra column to the table (computed column in this case) will affect all `SELECT *` queries. Make sure your application explicitly lists all columns in the `SELECT` statements or disregards any extra columns that might be returned.

docs/ssma/oracle/messages/o2ss0007.md

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -69,4 +69,5 @@ BEGIN CATCH
6969
END CATCH;
7070
```
7171

72-
>[!IMPORTANT] Trying to use `ISNUMERIC()` function in a check constraint for this scenario is not a viable solution, because `ISNUMERIC()` is designed to check for strings that might represent numeric values and not numeric underflow and overflow conditions.
72+
> [!IMPORTANT]
73+
> Trying to use `ISNUMERIC()` function in a check constraint for this scenario is not a viable solution, because `ISNUMERIC()` is designed to check for strings that might represent numeric values and not numeric underflow and overflow conditions.

docs/ssma/oracle/messages/o2ss0038.md

Lines changed: 3 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -20,7 +20,8 @@ A hierarchical query is a type of SQL query that handles hierarchical model data
2020

2121
When converting the hierarchical query, SSMA emulates it to a corresponding solution as a recursive query.
2222

23-
> [!NOTE] A recursive CTE can greatly simplify the code required to run a recursive query within a statement. Oracle's `START WITH` clause becomes the first nested `SELECT`, the base case of the recursion, to be `UNION`-ed with the recursive part which is just another `SELECT`.
23+
> [!NOTE]
24+
> A recursive CTE can greatly simplify the code required to run a recursive query within a statement. Oracle's `START WITH` clause becomes the first nested `SELECT`, the base case of the recursion, to be `UNION`-ed with the recursive part which is just another `SELECT`.
2425
2526
When aggregate function (i.e. `MAX`, `MIN`, etc.) is used as a part of sub query in a hierarchical query, SSMA cannot convert the hierarchical query to corresponding SQL Server query and generates a conversion error.
2627

@@ -130,7 +131,7 @@ You can now use SSMA to convert the result to SQL Server.
130131

131132
* O2SS0047: Hierarchical queries with asterisk not supported
132133
* O2SS0119: Hierarchical queries in sub query factoring clauses are not supported
134+
* [O2SS0268: Hierarchical query with OUTER JOIN cannot be converted](o2ss0268.md)
133135
* O2SS0285: Hierarchical query was not converted
134-
* O2SS0268: Hierarchical query with OUTER JOIN cannot be converted
135136

136137
In most of these situations, consider what the query is trying to accomplish and rewrite it to use the emulation.

docs/ssma/oracle/messages/o2ss0054.md

Lines changed: 3 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -33,9 +33,10 @@ BEGIN
3333
END;
3434
```
3535

36-
>[!NOTE] This is a bad code example of Oracle, as Oracle also generates an error message when you try to execute this code.
36+
> [!NOTE]
37+
> This is a bad code example of Oracle, as Oracle also generates an error message when you try to execute this code.
3738
38-
When you try to convert the above code in SSMA, it does not identify the user defined exception 'MYEXCEPTION_1' and hence generates the following error message:
39+
When you try to convert the above code in SSMA, it does not identify the user defined exception `MYEXCEPTION_1` and hence generates the following error message:
3940

4041
> O2SS0054: Unable to convert EXCEPTION_INIT
4142

docs/ssma/oracle/messages/o2ss0094.md

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -57,7 +57,8 @@ To resolve this error, you should perform the following steps:
5757

5858
The SSMA conversion option **Convert OPEN-FOR statements for REF CURSOR OUT parameters** is used because there is an ambiguity when a `REF CURSOR` output parameter is opened in the procedure. The `REF CURSOR` might be fetched in the caller procedure or used directly by the application (SSMA can handle this if the option is set to **Yes**).
5959

60-
>[!NOTE] After converting this query, SSMA generates a warning message **O2SS0259: CURSOR type was converted to VARCHAR (8000)**. You can generally ignore this warning.
60+
> [!NOTE]
61+
> After converting this query, SSMA generates a warning message **O2SS0259: CURSOR type was converted to VARCHAR (8000)**. You can generally ignore this warning.
6162
6263
## Related conversion messages
6364

docs/ssma/oracle/messages/o2ss0188.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -49,5 +49,5 @@ If the `SEQUENCE` that you are referencing is in another database using a databa
4949
## Related conversion messages
5050

5151
* O2SS0214: Column has bound sequence, but sequence was not found in source metadata
52-
* [O2SS0216: Call to identity sequence CURRVAL not supported](o2ss0216.md)
52+
* [O2SS0217: Call to identity sequence CURRVAL not supported](o2ss0217.md)
5353
* [O2SS0221: Call to identity sequence NEXTVAL not supported](o2ss0221.md)

docs/ssma/oracle/messages/o2ss0265.md

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -92,7 +92,8 @@ BEGIN
9292
END
9393
```
9494

95-
>[!NOTE] In general practice, the cursor should be fetched before doing any operation on `CURSOR` attributes. So for the above example, make sure to execute `FETCH c1 INTO @emp_no` before doing any operations on the cursor.
95+
> [!NOTE]
96+
> In general practice, the cursor should be fetched before doing any operation on `CURSOR` attributes. So for the above example, make sure to execute `FETCH c1 INTO @emp_no` before doing any operations on the cursor.
9697
9798
## Related conversion messages
9899

0 commit comments

Comments
 (0)